i want to display 1 to 10 numbers using one select statement.
Answer Posted / pramod kumar behera
select rownum from dual connect by level <=10;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Is sql dba a good career? : SQL DBA
What is multiple partition?
How long does it take to learn pl sql?
Can we use views in stored procedure?
What is the use of count (*) in sql?
What is the difference between an inner join and an outer join?
Is sql considered coding?
Is it important to partition hard disk?
Show how functions and procedures are called in a pl/sql block.
What does the base_object_type column shows in the user.triggers data dictionary view?
What is an alias command?
What does the sign mean in sql?
Write a query to find the names of users that begin with "um" in sql?
Why does sql need a server?
What view means?