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

Answer Posted / pramod kumar behera

select level from dual connect by level <=10;

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does truncate require commit?

532


How long it takes to learn pl sql?

523


How do I install sql?

512


what are the different index configurations a table can have? : Sql dba

562


How exception is different from error?

533






What is sql rowcount?

550


What is data manipulation language?

686


Explain the the update statement in sql?

562


how to calculate expressions with sql statements? : Sql dba

522


What are tables and fields?

578


What is the example of procedure?

506


What does <> sql mean?

526


What is a dirty read sql?

468


How do I view a sql trace file?

555


How do I truncate a sql log file?

525