Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest


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

Is sql difficult?

0 Answers  

why not null constraint showing its constraint type as 'c'

1 Answers  

Are stored procedures compiled?

0 Answers  

What is pl/sql table? Why is it used?

0 Answers  

What is the difference between drop and truncate commands?

0 Answers  

What is procedure explain with program?

0 Answers  

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

What are the different types of joins and explain them briefly.

3 Answers  

what is cursor procedure

1 Answers   iGate,

Is a view faster than a stored procedure?

0 Answers  

How do I access sql anywhere database?

0 Answers  

What is %s in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories