how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 9416 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / arunkumar t
select rownum from dual connect by rownum <=10
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to test null values?
How to delete a column in an existing table in oracle?
How do I call oracle stored procedures that take no parameters?
What is index in Oracle?
What are the attributes that are found in a cursor?
How can Oracle users be audited?
Is oracle the best database?
What are the types of trigger in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the difference between view and materialized view in Oracle?
What is the difference between I and G in Oracle?
How to get execution path reports on query statements?
How to join two tables in a single query using oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Explain oracle’s system global area (sga).
