how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 9366 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
Explain the characteristics of oracle dba?
How to use "in" parameter properly?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What do you understand by a database object? Can you list a few of them?
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.
Is the After report trigger fired if the report execution fails ?
Explain self joins in oracle?
What is a static data dictionary in oracle?
How to check the oracle tns settings?
Is oracle the best database?
What are the differences between primary key and unique key?
what is the scripts in data base?
What language does oracle use?
What is ordinary table in oracle?
Explain mutating triggers.
