i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 42553 Views
- HCL, Nyros, Oracle, I also Faced
- E-Mail Answers
Answer Posted / manoj
select level from dual connect by level<=10
| Is This Answer Correct ? | 113 Yes | 18 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
How can I change database name in sql?
How to take user input in pl sql?
What is break?
What is spool?
Why do you partition data?
Can instead of triggers be used to fire once for each statement on a view?
Does truncate table reset auto increment?
Is sql a programming?
What are the different types of functions in sql?
What does pl sql stand for?
How many types of cursors are available in pl/sql?
Can we use rowid as primary key?
Inline the values in PL/SQL, what does it mean.?
What are stored procedures in mysql?
Do stored procedures prevent sql injection?
