How many rows will return from dual table?
Answers were Sorted based on User's Feedback
Answer / sen
SELECT ROWNUM, LEVEL
FROM DUAL
CONNECT BY LEVEL < 5;
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / manoj
Any single row manipulation will work with dual. So only one
out put will work.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / amit kumar shrivastava
Oracle Provide DUAL table with only one row and one column.
So it will always return one row.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can we alter stored procedure?
What are the advantages of the packages
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
Can a table have no primary key?
How do you use a while loop in pl sql?
What are different types of keys?
how to retrive only second row from table?
How does an execution block start and end in pl sql?
What are joins in sql?
What does the file extension accdb stand for?
What is serial sql?
What are sql ddl commands?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)