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??
Answer Posted / ajitnayak
select rownum
from dual
connect by level <= (select max(a) from mising_values)
minus
select * from mising_values;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between null value, zero, and blank space?
What is nvarchar max in sql?
What is rtm in testing?
What is the use of index in sql?
What are pl sql data types?
What is sql in java?
What types of commands can be executed in sql*plus?
What are different types of indexes?
In pl/sql, what is bulk binding, and when/how would it help performance?
How do you update a value in sql?
What is the difference between delete and truncate commands?
What are expressions?
What is lexical units in pl sql?
What is column?
What is left inner join in sql?