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

What is the result of this query ?

SELECT * FROM EMP WHERE ROWNUM = 1

Question Posted / vishnu pratap mall

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

Please Help Members By Posting Answers For Below Questions

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

10717

Can you define an erp system?

673

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

1701

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

2316

Can you differentiate between mediator and osb?

621

What do you understand by soa and what are the benefits of using this architecture?

617

please send me forms, xml pulisher questions,answers

1650

How can a process be deployed in soa?

692

What is count(*) from po_vendors(any table)?

637

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

1644

Explain what are the tables of auto invoice?

640

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

1975

how can i print random rows in plsql table

1930

What is oracle soa suite?

760

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

627