Create Table Missingsquence ( Num Number); sql

suppose we have values like 1 5 7 in a colum.Now we want
numbers like(2 3 4 6) that exists between 1 5 7.How can we
do this using sql query??

Question Posted / kavitha n

5 Answers
9657 Views
Keane India Ltd, I also Faced
E-Mail Answers

Answer Posted / kavitha n

Create Table Missingsquence ( Num Number);

sql > select Num from Missingsquence ;

Missingsquence
--------------
1
5
7

SELECT LEVEL num
FROM DUAL
CONNECT BY LEVEL <= 7
MINUS
SELECT num
FROM missingsquence;

Is This Answer Correct ?

7 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is oracle database ? : Sql dba

966

What are joins in sql?

955

what is the difference between join and union? : Sql dba

1026

What is not in sql?

898

What is crud stand for?

930

What is triggering circuit?

1012

Can we use the cursor's to create the collection in PL/SQL?

958

What is sql trigger example?

997

How many sql core licenses do I need?

880

Is sql scripting language?

973

What does cursor do in sql?

969

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1003

Does execute immediate commit?

1149

what is the difference between char and varchar data types? : Sql dba

998

How many types of literals are available in pl sql?

1044