1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How many rows will return from dual table?

Question Posted / godi

Answers were Sorted based on User's Feedback



How many rows will return from dual table?..

Answer / godi

only one row one coloumn

Is This Answer Correct ?    31 Yes 3 No

How many rows will return from dual table?..

Answer / sen

SELECT ROWNUM, LEVEL
FROM DUAL
CONNECT BY LEVEL < 5;

Is This Answer Correct ?    9 Yes 2 No

How many rows will return from dual table?..

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

How many rows will return from dual table?..

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

Post New Answer

More SQL PLSQL Interview Questions

What is an invalid partition table?

0 Answers  

What is the use of primary key?

0 Answers  

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

What is difference between sql and oracle?

0 Answers  

How do I view stored procedures?

0 Answers  




how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

What is Data Concarency and Consistency?

1 Answers  

How do I trace sql profiler?

0 Answers  

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

define sql

3 Answers   Zensar,

What is difference between hql and native sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories