What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / vidyasagar

This is the actual answer

SQL> select * from emp where rownum=1;

EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
--------- ---------- --------- --------- --------- ---------
--------- ---------
123 SATYA 234
2000 40

got it

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is global tempory table?

6272


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

1678


Can you differentiate between mediator and osb?

616


What are file in oracle.

1795


where to define interorganization transaction charges and what are the different options?

1939






q)what are the validations in sql*loader

1729


Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1877


In hierarchical structure of a database? we have write query from where we should start?

1693


How to move the one file from one instance to another instance? And your scripts also?

603


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

1506


can we get profile values in report without using user exists is it possible how?

2308


how to print multi lay outs,muti currency,muti language in xml publisher

10688


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

661


testing tools?

1738


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2073