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



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

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

Post New Answer

More SQL PLSQL Interview Questions

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,


What are character functions in sql?

0 Answers  


how many columns can be used for creating index? : Sql dba

0 Answers  


What are the possible values for the boolean data field?

0 Answers  


A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,






What is a call statement? Explain with an example.

0 Answers  


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  


what are the 'mysql' command line arguments? : Sql dba

0 Answers  


What does data normalization mean?

0 Answers  


What is a behavioral trigger?

0 Answers  


how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  


Can %notfound return null after a fetch?

0 Answers  


Categories