Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5748 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
How do I use google cloud in sql?
What is auto increment feature in sql?
What kind of join is join?
How many types of keys are there in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Write the alter statement to enable all the triggers on the t.students table.
What is oracle pl sql developer?
How do I save the results of sql query in a file?
Is time a data type in sql?
how to decrement dates by 1 in mysql? : Sql dba
What is composite data type in pl sql?
What is mdf ldf and ndf?
Why function is used in sql?
What is the difference between inner join and left join?
How do I edit a stored procedure?
