SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10) WHERE n&

how to produce numbers from 1 to 10 using dual table

Question Posted / nihar ranjan nath

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

Please Help Members By Posting Answers For Below Questions

how to join query for one source type is oracle another source type is sql server ?

2379

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

1017

What is an oracle wallet?

882

What is the difference between a hot backup and a cold backup in oracle?

961

How to insert a record into a table?

1021

Can we convert a date to char in oracle and if so, what would be the syntax?

960

How to export your connection information to a file?

1076

Give the different types of rollback segments.

980

What to do if dba lost the system password?

1091

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

How to create lov dynamically at runtime & attach to text field?

1098

What is a tns service name?

944

What are the four Oracle system processes that must always be up and running for the database to be useable?

956

What is a select query statement in oracle?

901

What happens to the indexes if a table is recovered?

944