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

Answer Posted / mkumar.it

select rownum from user_objects where rownum <= 10

Is This Answer Correct ?    71 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is program debugging?

552


What do you understand by pl/sql records?

526


What is sqlca in powerbuilder?

554


Does a join table need a primary key?

522


Can I learn sql in a week?

541






Why do we use %rowtype & %type in plsql?

592


How many commands are in sql?

517


How do you concatenate in sql?

544


How many types of indexes are there in sql?

531


How many developers work on postgresql?

553


How can you view the errors encountered in a trigger?

538


What is the difference between left join and right join?

494


What is meant by temporal data?

532


give the syntax of grant and revoke commands? : Sql dba

607


define join and explain different type of joins? : Sql dba

542