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

Name three sql operations that perform a sort.

582


What is view explain with example?

517


What pl/sql package consists of?

636


What are the packages in pl sql?

570


What is lexical units in pl sql?

571






What is a sql profiler?

590


Is a view faster than a stored procedure?

542


Explain 3 basic parts of a trigger.

830


How to select unique records from a table?

568


What does desc stand for?

588


How to call shell script from pl sql procedure?

625


Explain select statements in sql?

584


what are properties of a transaction? : Sql dba

559


what is the difference between truncate and delete statement? : Transact sql

544


what is cross join? : Sql dba

570