Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 10934 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / nihar ranjan nath
SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an oracle tablespace?
What are the oracle differences between nvl and coalesce
How to create a table in a specific tablespace?
What is oracle used for?
Does oracle database need java?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the difference between Delete, Truncate and Drop in Oracle?
Explain the difference between sql and oracle?
Explain the use of inctype option in exp command.
How to install oracle database 10g xe?
Explain the dml?
What is the maximum number of triggers that can be applied to a single table?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What are the general rules on data consistency?
What is the usage of control file in oracle?
