var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get rows not present in table
Can you please help me to achieve below scenario.
I have a table random_numbers, where I have inserted numbers between 1-10 and 80 - 90.
Now, how can I get numbers 11-79 and 91-100 i.e. the numbers which are not present in the table without joining with other tables.
Note: Above values is just an example, i.e. the query or for loop should not be hard coded.
Your help is very much required.
"Row generator" is the keyword here.
An example: get numbers that aren't stored in the TEST table:
SQL> select * from test;
SQL> select level
2 from dual
3 connect by level <= (select max(col) from test)
5 select col from test;