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
What are the two different parts of the pl/sql packages?
How do I count rows in sql query?
What is the function that is used to transfer a pl/sql table log to a database table?
what is sql in mysql? : Sql dba
What is normalization? How many normalization forms are there?
Is sql between inclusive?
how to create a new table in mysql? : Sql dba
Is primary key clustered or nonclustered?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
what are set operators in sql? : Sql dba
What are the various levels of constraints?
Why self join is used in sql?
What is materialized view in sql?
Is a foreign key always unique?
Show the two pl/sql cursor exceptions.