What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
Suggest New Category

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / nakul28

25 Answers
33999 Views
IBM, Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / pulakesh dey

It will not display any record. Rownum is a pseudo column.
This column only will be populated once the result set is
generated. That is the reason if you write a same query in
ascending or descending order the rownum of a specific
record will be different.

Is This Answer Correct ?

8 Yes

13 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / archana patil

It won't display any record. It return with zero or no records.

Is This Answer Correct ?

0 Yes

6 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / 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

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / prakash

it will gives result:no rows returned.

because rownum applicable onle < or <=
not use > or >=.

Is This Answer Correct ?

13 Yes

24 No

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1..

Answer / raju

it will displays the all records

Is This Answer Correct ?

3 Yes

71 No

Post New Answer

More Oracle Apps Technical Interview Questions

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

0 Answers Cap Gemini,

What is Place holder Columns?

3 Answers

how do you describe O2C along with tables

0 Answers TCS,

when will formula,place holder and summary columns fire in reports?

1 Answers TCS,

what do u mean by debit/credit memo invoices?

3 Answers ACC, Convergys, Mascon,

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers Accenture,

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers

How can a process be deployed in soa?

0 Answers

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers iGate,

why we can use synonym?

6 Answers

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers Accenture,

In one flat file i got headers and lines data how you can write control file now ?

1 Answers KPMG,

For more Oracle Apps Technical Interview Questions Click Here