THE CONDITION ROWNUM = 1 EVALUATE TRUE(i.e 1=1) HENCE IT DISPLAY THE FIRST

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / kumar

Answer Posted / kumar

THE CONDITION ROWNUM = 1 EVALUATE TRUE(i.e 1=1) HENCE
IT DISPLAY THE FIRST RECORD FROM THE EMP TABLE.

Is This Answer Correct ?

28 Yes

3 No

Please Help Members By Posting Answers For Below Questions

tell me the scenarios of the independent in reports

2221

List the various types of value set.

713

What do you understand by concurrent programs?

706

What is a value set? List its various types.

736

What do you understand by soa and what are the benefits of using this architecture?

707

What is the concept of soa governance?

872

Plz anybody send me Technical specification for AP Interface

2148

Do you know what is applysys in oracle application database schema, what is apps?

770

testing tools?

1857

pls send me out bound code of supplers,site,bankiformation code pls as soon as

1859

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

2260

Can you explain the difference between architecture followed in 10g & 11g?

747

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

2232

how can i print random rows in plsql table

2033

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3191