Interested to Buy Any Domain ? << Click Here >> for more details...
how to produce numbers from 1 to 10 using dual table
- 4 Answers
- 11055 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / nihar ranjan nath
SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain alias?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Explain mutating triggers.
How to create id with auto_increment on oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
What do you mean by group by clause?
State all possible different index configurations a table can possibly have?
What are the differences between blob and clob in oracle?
How many types of cluster table in Oracle?
Can sub procedure/function be called recursively?
Explain compound trigger in oracle?
What are set operators?
what is insert all statement in sql
State and explain the different types of data models?
Point the difference between translate and replace?
