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

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / apps

ROWNUM is generally used in >=, <=, <, >. But there is
exception, you can use it = also but only with 1 as
ROWNUM=1, it will display first record in table. If you use
ROWNUM=10…. Or any number other than 1 then it will not
display any records.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you register report in oracle apps?

1099


What is a value set? List its various types.

1100


Tell me how to debug the report?

1125


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634


In support project one ticket alloted which steps follows manualy tell me ?

2666


What are the different components you should consider while defining a responsibility in oracle apps?

1086


Can we create tables in apps schema?

1144


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2133


List the types of flexfield?

1044


Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2618


What is oracle soa suite?

1244


do you know is it possible to run the interface without using oracle apps?

1123


what is the differences between internal requisition and internal sales order?

2662


what is global tempory table?

7217


what is pay run id ?

2197