Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5690 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 sql schema used for?
What is a recursive join sql?
Explain the purpose of %type and %rowtype data types?
Why do we use cursors?
Can you have more than one trigger on a table?
Can we commit in trigger?
What is recursive stored procedure?
Can a varchar be a primary key?
How to make a copy values from one column to another in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
What is substitution variable in pl sql?
What is the difference between a subquery and a join?
What is sql and its types?
What is null in pl/sql?
How many rows can sqlite handle?
