Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5750 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to write html code in pl sql?
what is the syntax used for partition in tsql? : Transact sql
What is an example of translating a date into julian format?
How to fetch the rows by dynamicaly passing table name through cursor?
what is blob? : Sql dba
What does desc stand for?
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Why do we create stored procedures & functions in pl/sql and how are they different?
How to sort the rows in sql.
What plvcmt and plvrb does in pl/sql?
How toimport .dmp file in lower version of oracle from higher version ?
What are different types of keys?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
