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
How do I start tns listener?
Explain table?
What is the parameter mode that can be passed to a procedure?
What is hot backup and logical backup?
What is a subquery in oracle?
Can we connect to ORACLE db using Windows Authentication?
What is analyze command used for?
What is where clause in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is the difference between 10g OEM and 11g OEM?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
In the oracle version 9.3.0.5.0, what does each number shows?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to update a table row with a record?