Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5588 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 |
What is sqlexception in java?
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
How do I edit a stored procedure?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
What is the Query to print out the individual total number of duplicate row in sql.
What is the difference between left outer join and left join?
what is heap table? : Sql dba
Are subqueries faster than joins?
What is the use of stored procedures?
What is auto increment?
what is the difference between delete and truncate statement in sql? : Sql dba
-
Oracle (3259) - 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)
