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...

How many rows will return from dual table?

Answer Posted / sen

SELECT ROWNUM, LEVEL
FROM DUAL
CONNECT BY LEVEL < 5;

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are all the different normalizations? : Sql dba

1120


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1177


What are local and global Indexes and where they are useful.

1494


What is memory optimized?

1135


how to write date and time literals? : Sql dba

1010


What is record type in pl sql?

1036


What is difference between primary and secondary key?

1073


Is stored procedure faster than query?

1020


How many primary keys can a table have?

1058


How many types of indexes are there in sql?

1041


how many triggers are allowed in mysql table? : Sql dba

1103


How do I count rows in sql?

1050


Explain the the update statement in sql?

1105


Is foreign key mandatory?

1064


What is a database trigger?

1135