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
how to get help information from the server? : Sql dba
What is sql architecture?
What are the subsets of sql?
How do I save a stored procedure?
What is trigger and types?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what are ddl statements in mysql? : Sql dba
what is the difference between char_length and length? : Sql dba
what is sql in mysql? : Sql dba
What is difference between function and trigger?
Is there a way to automate sql execution from the command-line, batch job or shell script?
How to download oracle sql developer?
What is bind variable in pl sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How do I send sql query results to excel?