Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5692 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 can I change database name in sql?
what is a composite primary key ? : Sql dba
How do you retrieve the last N records from a table?
How do you know if a relationship is 2nf?
What is pl sql record in oracle?
What are commit, rollback, and savepoint?
can i create trigger on synonym is it possible or not please help me
Differentiate between sga and pga.
Is join an inner join?
what are the t string functions available in tsql? : Transact sql
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
how to create a new table by selecting rows from another table in mysql? : 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)
