What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / rajesh

It gives all the details of the Employee who is in the first
row of the table .


Regards
Rajesh

baburajeshd@gmail.com

Is This Answer Correct ?    58 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1798


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

645


Tell me how to debug the report?

637


What is sca and how is it useful?

656


Can you define an erp system?

675






how can i print random rows in plsql table

1933


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1647


How is choreography different from orchestration?

648


Tell me where we find the status of order information?

667


what are the different transaction clauses in AR?

1598


Explain oracle apps architecture.

760


What do you understand by soa?

689


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

1701


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

614


What are the Standard Reports and Forms in HRMS?

1770