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

how to get a list of columns in an existing table? : Sql dba

711


What are the advantages of pl sql over sql?

733


What is the difference between explicit and implicit cursors in oracle?

700


what is the difference between char_length and length? : Sql dba

789


how many sql dml commands are supported by 'mysql'? : Sql dba

791






What is blind sql injection?

757


What are the advantages of pl sql?

835


How do you concatenate in sql?

725


What are the different sql commands?

724


How do we use distinct statement? What is its use?

752


What is rownum and rowid?

761


how to present a past time in hours, minutes and seconds? : Sql dba

740


Which function is used to return remainder in a division operator in sql?

787


How to find 3rd highest salary of an employee from the employee table in sql?

790


how to return query output in html format? : Sql dba

851