how to produce numbers from 1 to 10 using dual table

Answer Posted / arunkumar t

select rownum from dual connect by rownum <=10

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a string to a date in oracle database?

539


Can sub procedure/function be called recursively?

525


What do you mean by merge in oracle and how can you merge two tables?

513


What is the use of aggregate functions in oracle?

571


Give the constructs of a package, function or a procedure.

529






How do I use unicode codesets with the weblogic jdriver for oracle driver?

542


What is an Oracle Instance?

678


What suggestions do you have to reduce the network traffic?

535


What to do if the binary spfile is wrong for the default instance?

553


What is dual table oracle?

517


What is ceil and floor in oracle?

565


What are data pump export and import modes?

599


How to convert csv to table in oracle?

517


How to drop a stored procedure in oracle?

580


What do you know about normalization? Explain in detail?

493