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
Is there any restriction on the use of union in embedded sql?
how to get help information from the server? : Sql dba
what are the advantages and disadvantages of views in a database? : Sql dba
How do I write a sql query in pgadmin 4?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What jobs use sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What are the most important ddl statements in sql?
Which join is like inner join?
what is cursor. write example of it. What are the attributes of cursor.
What is sqlservr exe?
What is application trigger?
Can one improve the performance of sql*loader? : aql loader