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

Answer Posted / pramod kumar behera

select rownum from dual connect by level <=10;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data types in sql?

537


Can we commit inside a trigger?

552


What is trigger explain it?

551


Explain sql data types?

629


What language is oracle sql developer?

512






Why is a primary key important?

547


What is equi join in sql?

617


Explain what is a column in a table?

578


how many columns can be used for creating index? : Sql dba

524


Can %notfound return null after a fetch?

593


Define implicit and explicit cursors.

633


what are the types of subquery? : Sql dba

592


What is a stored procedure in sql with example?

606


What is foreign key sql?

557


What is a relationship and what are they?

582