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 a primary key be a foreign key?
What is crud sql?
What is the difference between in and between in sql?
What is raid? How does it help storage of databases?
What are the advantages of pl sql?
explain what is mysql? : Sql dba
What version is sql?
What plvcmt and plvrb does in pl/sql?
Does sql support programming?
How many rows can sqlite handle?
Can I call a procedure inside a function?
What are the benefits of pl sql?
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)