Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5670 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 are pl/sql cursors?
What is benefit of creating memory optimized table?
How to run pl/sql statements in sql*plus?
What is pessimistic concurrency control? : Transact sql
Does asenumerable execute the query?
What is view? Can we update view
What is orm in sql?
What is flag in sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is null in pl/sql?
How to get unique records from a table?
What is sqlcontext?
How to get list of all tables from a database?
Why is pl sql needed?
How many functions are there in sql?
