Recently I observed the following syntax:  AND TRUNC (SYSDATE) + 1 BETWEEN a(+) AND b(+)   I know that the (+) sign is used to address left or right join in conditions like:  and a = b(+)   ... but I have no idea what it means in the BETWEEN function.  Can someone explain, please, or better give an example using BETWEEN function?  Thank you,
Found the following in an Oracle-based application that we're migrating (generalized):  SELECT     Table1.Category1,     Table1.Category2,     count(*) as Total,     count(Tab2.Stat) AS Stat FROM Table1, Table2 WHERE (Table1.PrimaryKey = Table2.ForeignKey(+)) GROUP BY Table1.Category1, Table1.Category2   What does (+) do in a WHERE clause? I've never seen it used like that before.
I've found  many queries to check edit counts, and I get different results for each one. Which one is the most accurate and up-to-date query? Or is there any way to see the edit count in stats? Shoot, Shoot At I have a question about the difference between the verb "shoot" and "shoot at":          Police shot the suspect.     Police shot at the suspect.        Are they just the same? A field extension of prime degree Suppose that $E$ is an extension of $F$ of prime degree. Show that $~~\forall~ a \in E : ~ F(a)=F$ or $F(a)=E$   Attempt: Suppose that $E$ is an extension of a field $F$ of prime degree, $p$. Therefore $p = [E :F] = [E : F(a)][F(a) : F]$. Since $p$ is a prime number, we see that either $[E : F(a)] = 1$ or $[F(a) : F] = 1$.   Now, $[E : F(a)] = 1 \implies $ there is only one element $x \in E$ which forms a basis and every element in $E$ is generated by $x$ i.e. $E = \{x~c~|~ c \in F(a)\}$  $[F(a) : F] = 1 \implies $ there is only one element $y \in F(a)$ which forms a basis and every element in $F(a)$ is generated by $y$ i.e. $F(a) = \{y~d~|~ d \in F\}$  Have I inferred it correctly? How do I move ahead?  Thank you for your help. I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shapefile). I have managed to convert it as CSV file and load it into QGIS (displays data fine) but I have trouble to convert it to a shapefile.  I can view it but I can´t add or alter data in this file. I think I have to save it as a database.   Any clues how to convert the xlsl-data to a database and finally to a shapefile? In reading I am not sure if the issue below could have something to do with needing a custom wordpress ajax handler? All of these functions are inside my functions.php file. I have a couple of PHP functions that are supposed to pass information from one to another. The an AJAX call to the final function should produce the final result through that call. Its not happening. My count results in 0 and I am not understanding why. If I replace my query with a static array like [44,55,99,33] then it will pass the values ok. Likewise if I keep the query and simply replace the $id in the query and make it a static id such as '20' then it works. I would think that the id was the issue then and it wasnt pulling properly but it seems to work ok just not pass? function idx(){     global $wpdb, $id;       $getId = $_SERVER['REQUEST_URI'];     $ecp = explode('/', $getId);     if($ecp[3] != ''){         $id = $ecp[3];     }         return $id; } add_action( 'after_setup_theme', 'idx' );  =============================================== function Total_Result(){     global $wpdb;     $id = idx();        /*$resultx = [44,88,59,52];*/ ;      $resultx = $wpdb-&gt;get_results( $wpdb-&gt;prepare(&quot;SELECT * FROM {$wpdb-&gt;prefix}custom_form_submission_conversation as cc LEFT JOIN {$wpdb-&gt;prefix}custom_form_submission as cs on cc.fsid ='$id' WHERE fsid='$id'&quot; ));          $resultxs = array($resultx);          $total_result =  count($resultxs[0]);     echo  $total_result; }  when I var_dump $resultx I get: array(3) { [0]=&gt; object(stdClass)#1256 (36) { [“cid”]=&gt; string(3) “167” [“fsid”]=&gt; string(2) “20” [“specified_date”]=&gt; string(3) “yes” [“price_quote”]=&gt; string(4) “1140” [“posted_by”]=&gt; string(9) “dc_vendor” [“limit_count”]=&gt; string(1) “1” [“read_unread”]=&gt; string(1) “1” [“vendor_response”]=&gt; string(4) “zero” [“date_created”]=&gt; string(19) “2021-04-15 11:39:08” }   [1]=&gt; object(stdClass)#1257 (36) { [“cid”]=&gt; string(3) “186” [“fsid”]=&gt; string(2) “20” [“specified_date”]=&gt; string(3) “Yes” [“price_quote”]=&gt; string(3) “602” [“posted_by”]=&gt; string(8) “customer” [“limit_count”]=&gt; string(1) “1” [“read_unread”]=&gt; string(1) “1” [“vendor_response”]=&gt; string(4) “zero” [“date_created”]=&gt; string(19) “2021-04-15 11:39:08” }   [2]=&gt; object(stdClass)#1258 (36) { [“cid”]=&gt; string(3) “188” [“fsid”]=&gt; string(2) “20” [“specified_date”]=&gt; string(3) “yes” [“price_quote”]=&gt; string(4) “1017” [“posted_by”]=&gt; string(9) “dc_vendor” [“limit_count”]=&gt; string(1) “1” [“read_unread”]=&gt; string(1) “0” [“vendor_response”]=&gt; string(4) “zero” [“date_created”]=&gt; string(19) “2021-04-15 11:39:08” } }   so then I try and pass that data like so: function getvendorresponsestatus() {     global $wpdb; $id = idx();          $total_resultx = Total_Result($id);         die; }  Ive tried with and without the die();. The AJAX call is: setInterval(function(){     var ffiidd = jQuery('#ffiidd').val();     var ajaxurl = &quot;&lt;?php echo admin_url('admin-ajax.php'); ?&gt;&quot;;          jQuery.post(ajaxurl, {         action: &quot;vendorAjaxprog&quot;,         ffiidd: ffiidd     }, function(data) {         console.log(data);         jQuery.post(ajaxurl, {             action: &quot;getvendorresponsestatus&quot;, //&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; this is the action that calls the function             fsid : ffiidd         },         function(datas) {             console.log('+ datas);             jQuery('.cust_vendor_top').html(datas);         });         if(data == 0){}else{             jQuery('.ajaxreload').html(data);                                     }     });               }, 5000);/*==30 seconds==*/  So the question is why wont it pass along the query array information but it passes a basic array or it will pass if I change the id in the query to be static? I know the query is good because of when I var_dumped it, I have results before I get to the Total_Result() function. Settings disappeared in Ubuntu 19.10 I usually go to the right top corner and at the drop down menu I select the tool icon to go to the settings.  However, 19.10 does not have a tool icon.  How can I go to settings now? How to install H.265 / HEVC codec on Ubuntu Linux? I have seen that the new  shows off H.265/HEVC playback, the successor of H.264. I wonder how I may get this support in Linux. Is there a need to install a codec specific for this format? How? EntityFramework - contains query of composite key How do I find a command if I don't know its name? Finding a formula to sum natural numbers up to $n$ Possible Duplicate:          I got this question in homework:  Find an expression for the sum ‫‪     $\sum k = 1 +\cdots + n‬‬$.    and prove it using an induction.   I'm not even near finding the expression. What I did notice is that if $n$ is (for example) 5 then the sum would be   $5^2 - 4^2 + 3^2 - 2^2 + 1^2$  So the first number is always positive and from there on the sign changes.  Any tips on how do I contintue from this point on, assuming I'm in the right direction?  Thanks! Using Python to convert from more than one CRS I have a Python function which converts Eastings and Northings to Latitude and Longitude if line_count == 0:                     keys = row                     print('keys', keys)                     line_count += 1                 else:                     inProj = Proj(init='epsg:27700') # British National Grid                     outProj = Proj(init='epsg:4326') # WGS84                     x1, y1 = row[1], row[2]  # easting, northing                     x2, y2 = transform(inProj, outProj, x1, y1)                     row[1], row[2] = y2, x2                                          json_doc = {}  At the moment it converts from epsg:27700 (British National Grid) to WGS84, however there is a possibility I will get TM75 Irish Grid too. Is there any way I can get Python to recognised which CRS is applicable for the conversion? Find $ P(Z>X+Y)$ where $X,Y,Z \sim U(0,1)$ independently I'm trying to follow a line in a derivation for $P(Z&gt;X+Y)$ where $X,Y,Z$ are independent continuous random variables distributed uniformly on $(0,1)$.  I've already derived the pdf of $X+Y$ using the convolution theorem, but there's a line in the answer that says:  $P(Z&gt;X+Y) = \mathbb{E}[\ P(Z&gt;X+Y\ |\  X+Y )\  ]$ where $\mathbb{E}$ is the expectation.  I'm not familiar with this result. Could anyone give a pointer to a similar result if one exists?  Thanks. SQL Server Linked Server to Microsoft Access Rigorous proof that surjectivity implies injectivity for finite sets I want to use the "BackSpace" button as a shortcut key on nautilus. I want to return to the previous folder whilst browsing the Home folder, just like windows 7.   Also I want the same thing while using Firefox, In a way that when I press the shortcut key I will return to the previous web page. custom button visibility list view Understanding my electrical panel I just purchased .  I'll be installing it in my RV.  Current will be supplied by a 12VDC to 120VAC, 3000W inverter.  I'll be using Single-Pole Type BR breakers.  Here's a picture of the box:    My current understanding is that I must install a grounding bar to the box.  This is my current understanding of how to connect the breaker to the main supply.:    Here is my understanding of how I would wire in new circuits:    Does this look right?  I would really appreciate your help -- I've been beating myself over the head about this. Reapplying for a UK Standard Visitor visa after a refusal Most of the wand-carriers that come from a non-Muggle family seem fairly uneducated when it comes to interacting with Muggles.  This implies that they don't go to any type of Muggle school before entering into their education at Hogwarts (or whichever Wizarding school they go to), or else they would at least understand some Muggle culture.  What do children from magical families do before going to Hogwarts if they don't go to a traditional school?  Is there any evidence that they're homeschooled? Why are the dineutron and diproton unbound?