Sign Up Login


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

select 10 from dual; y its showing all the rows with 10?

Question Posted / guest


select 10 from dual; y its showing all the rows with 10?..

Answer / honey

1.
As we know that Implicitly Cursor 'SQL' is opened.
when it is pin pointing the 1st row in the dual, cursor
found that one record exists.
2.
since there are no conditions (i.e., where,group by,..),
directly 'select' clause will be executed.
3.
Internally Oracle identifies numbers, so 10 number will be
displayed.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

What is the use of %rowtype?

0 Answers  

What are types of joins?

0 Answers  

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

Explain the advantages and disadvantages of stored procedure?

0 Answers  

Can we perform dml in function?

0 Answers  




Is hadoop a nosql?

0 Answers  

Is sql dba a good career? : SQL DBA

0 Answers  

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

What plvcmt and plvrb does in pl/sql?

0 Answers  

What is sql*plus?

0 Answers  

What is mutating table error?

0 Answers  

Which are the most commonly used sql joins?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories