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

What is Referential Integrity?

3 Answers  

What is difference between procedure and trigger?

0 Answers  

Explain mutating table error.

0 Answers  

What sql database should I use?

0 Answers  

Which command is used to delete a trigger?

0 Answers  

what is definer rights invoke rights?

1 Answers  

How to write pl sql program in mysql command prompt?

0 Answers  

What are the disadvantages of file system?

0 Answers  

What is thread join () in threading?

0 Answers  

Why is stored procedure faster than query?

0 Answers  

How do you remove duplicate records from a table?

0 Answers  

What is sqlca in powerbuilder?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories