What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Answer Posted / vishnu pratap mall

it will display all records of the employee of the first row
in the table.

Is This Answer Correct ?    2 Yes 9 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?

1804


Explain what are the tables of auto invoice?

650


How to create a purchase order without a requisition?

632


how can develope the po variance and po summary report? with tables mandatory columns and query please?

1978


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

1657






What are the different components of soa suite?

726


What is instead of trigger in where we will use?

680


What is a value set? List its various types.

650


What are file in oracle.

1814


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

637


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

2130


Is soa a part of oracle fusion middleware?

607


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

1692


What is oracle soa suite?

768


Can u give the Documentation of Custom.pll in oracle apps

2998