select 10 from dual; y its showing all the rows with 10?
Answer Posted / 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 View All Answers
Are subqueries faster than joins?
How do you remove duplicates without using distinct in sql?
what is sql server agent? : Sql dba
Can we rollback delete command?
Is it mandatory for the primary key to be given a value when a new record is inserted?
Define commit?
What are sql ddl commands?
What is flag in sql?
What is the difference between mdf and ndf files?
What is sql*loader and what is it used for? : aql loader
How do rank () and dense_rank () differ?
How do I view a sql database?
What is an ndf file?
Is pl sql a programming language?
What is implicit cursor in pl sql?