how to produce numbers from 1 to 10 using dual table
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
Which are the five query types available in oracle?
What to do if the startbd.bat failed to start the xe instance?
How remove data files before opening a database?
How to bring a tablespace online?
What are a cluster and non-cluster index?
How to convert csv to table in oracle?
What is difference between cartesian join and cross join?
What is the relationship among database, tablespace and data file?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to count duplicated values in a column in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
What is where clause in oracle?
What is connection pooling in oracle?
How translate command is different from replace?
What is program global area (pga) in oracle?