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 show all tables with 'mysql'? : Sql dba
Can %notfound return null after a fetch?
How to get list of all tables from a database?
What is exit statement?
What is java sql drivermanager?
What is vector point function?
Explain aggregate functions are available there in sql?
What is sql*plus?
How do I clear the screen in sql plus?
What is record in pl sql?
What is the difference between a database and a relational database?
What is sql basics?
Is pl sql different from sql?
What is the difference between numeric and autonumber?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5