i want to display 1 to 10 numbers using one select statement.

Answer Posted / manoj

select level from dual connect by level<=10

Is This Answer Correct ?    113 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does pl/sql support create command?

586


how to install mysql? : Sql dba

598


Explain how can you save or place your msg in a table?

607


What is the purpose of the partition table?

560


Define commit?

572






What are pl/sql cursor exceptions?

587


What is difference between stored procedures and application procedures?

586


How many times can we commit in a loop?

582


What are user defined functions?

590


What is the current version of sql?

553


What is the difference between truncate and drop statements?

589


what are sequences

1113


Which kind of parameters cannot have a default value in pl sql?

608


How can I speed up sql query?

540


How do sql databases work?

540