how to retrieve unmatched data from a column.. - OracleConnections2024-03-29T15:43:26Zhttp://www.oracleconnections.com/forum/topics/how-to-retrieve-unmatched-data-from-a-column?commentId=6612035%3AComment%3A6825&feed=yes&xn_auth=noIt appears you are dumping a…tag:www.oracleconnections.com,2013-05-31:6612035:Comment:66722013-05-31T05:45:46.859ZAsa Labrecquehttp://www.oracleconnections.com/profile/AsaLabrecque
<p>It appears you are dumping a bunch of interview questions in this forum</p>
<p><a href="https://forums.oracle.com/forums/thread.jspa?threadID=2543023&tstart=0" target="_blank">https://forums.oracle.com/forums/thread.jspa?threadID=2543023&tstart=0</a><br></br><a href="https://forums.oracle.com/forums/thread.jspa?threadID=2543024&tstart=0" target="_blank">https://forums.oracle.com/forums/thread.jspa?threadID=2543024&tstart=0</a><br></br> …</p>
<p>It appears you are dumping a bunch of interview questions in this forum</p>
<p><a href="https://forums.oracle.com/forums/thread.jspa?threadID=2543023&tstart=0" target="_blank">https://forums.oracle.com/forums/thread.jspa?threadID=2543023&tstart=0</a><br/><a href="https://forums.oracle.com/forums/thread.jspa?threadID=2543024&tstart=0" target="_blank">https://forums.oracle.com/forums/thread.jspa?threadID=2543024&tstart=0</a><br/> <a href="https://forums.oracle.com/forums/thread.jspa?threadID=2543021&tstart=0" target="_blank">https://forums.oracle.com/forums/thread.jspa?threadID=2543021&tstart=0</a><br/> <a href="https://forums.oracle.com/forums/thread.jspa?threadID=2543026&tstart=0" target="_blank">https://forums.oracle.com/forums/thread.jspa?threadID=2543026&tstart=0</a></p>
<p>Bad enough in itself, but worse in that none of them have anything to do with the subject of this forum: "Database Security".<br/> You go to an interview armed with your knowledge and experience. If your prep for an interview is to cram for it as if it were a test, one of two things will happen:<br/> 1 - If the people conducting the interview know anything at all they will quickly see through you and you won't get the job.<br/> 2 - You will get the job and both you and your manager will quickly discover that you are in way over your head.</p> no no, i understand the conce…tag:www.oracleconnections.com,2013-05-31:6612035:Comment:66692013-05-31T05:37:08.183ZMarvin Cambrehttp://www.oracleconnections.com/profile/MarvinCambre
<p>no no, i understand the concept of minus set operator, it is an interview question.. i just want to identy the missed numbers from 1..100 in a single query</p>
<p>no no, i understand the concept of minus set operator, it is an interview question.. i just want to identy the missed numbers from 1..100 in a single query</p> from here
MINUS Example The f…tag:www.oracleconnections.com,2013-05-31:6612035:Comment:68252013-05-31T05:36:05.523ZAsa Labrecquehttp://www.oracleconnections.com/profile/AsaLabrecque
<p>from here</p>
<pre class="jive-pre"><code class="jive-code jive-java">MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second: SELECT product_id FROM inventories MINUS SELECT product_id FROM order_items;</code></pre>
<p>from here</p>
<pre class="jive-pre"><code class="jive-code jive-java">MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second: SELECT product_id FROM inventories MINUS SELECT product_id FROM order_items;</code></pre>