It will return first record of the table..

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / abhay

Answer Posted / abhay

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

q)what are the validations in sql*loader

2406

How many schemas we have? how many you have used?

2069

how can i print random rows in plsql table

2500

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

2219

How do you register report in oracle apps?

1099

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

2107

What are do's and dont's of Interface?

2431

Can we create tables in apps schema?

1143

What do you understand by concurrent programs?

1103

what are the different transaction clauses in AR?

2121

Tell me where we find the status of order information?

1140

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

1125

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

1179

Tell me how to debug the report?

1125

tell my any difficult situtation you solved in your experience in your company?

2320