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


Please Help Members By Posting Answers For Below Questions

Which are the five query types available in oracle?

605


What to do if the startbd.bat failed to start the xe instance?

689


How remove data files before opening a database?

650


How to bring a tablespace online?

614


What are a cluster and non-cluster index?

652






How to convert csv to table in oracle?

610


What is difference between cartesian join and cross join?

658


What is the relationship among database, tablespace and data file?

631


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??

1438


How to count duplicated values in a column in oracle?

636


What is the difference between Delete, Truncate and Drop in Oracle?

698


What is where clause in oracle?

628


What is connection pooling in oracle?

635


How translate command is different from replace?

633


What is program global area (pga) in oracle?

685