1. As we know that Implicitly Cursor 'SQL' is opened. when it

select 10 from dual; y its showing all the rows with 10?

Question Posted / honey

1 Answers
5589 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

Please Help Members By Posting Answers For Below Questions

What are the benefits of triggers?

1119

What is materialized view in sql?

871

What is trigger price?

925

What is a loop in sql?

936

what is msql? : Sql dba

939

What normalization means?

905

What are tables and fields?

973

Does sap use sql?

928

What is cartesian join in sql?

1028

How do I count duplicates in sql?

1027

How do I save a sql query?

961

what is online transaction processing (oltp)? : Sql dba

935

what is data control language? : Sql dba

957

What is use of trigger?

873

Explain isolation levels. : Transact sql

1015