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

What is the need of merge statement?

550


How do I count duplicates in sql?

545


How delete all records from table in sql?

549


Which table is left in join?

516


How does sql*loader handles newline characters in a record? : aql loader

586






Define concurrency control. : Transact sql

582


What is sharding in sql?

564


What is offset in sql query?

593


What is primary key in db?

517


Why does sql need a server?

561


How would you pass hints to the sql processor?

525


Why do we use triggers?

515


where are cookies actually stored on the hard disk? : Sql dba

578


What is an escape character in sql?

562


What is native sql query?

546