select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5252 Views
- I also Faced
- E-Mail Answers
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
What is a pl/sql block?
What do we need to check in database testing?
What does trigger mean in slang?
Is sql database free?
How to start the command-line sql*plus?
What is database white box testing and black box testing?
Is sql easier than java?
Can we use ddl commands in pl sql?
How do I remove all records from a table?
What are stored procedures in mysql?
What is prepared statement in sql?
What does over partition by mean in sql?
How do sql triggers work?
what is the syntax used for partition in tsql? : Transact sql
What is a unique key?
