What is the result of this query ?
SELECT * FROM EMP WHERE ROWNUM = 1
- 25 Answers
- 29088 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answer Posted / vidyasagar
This is the actual answer
SQL> select * from emp where rownum=1;
EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
--------- ---------- --------- --------- --------- ---------
--------- ---------
123 SATYA 234
2000 40
got it
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Do you know what is applysys in oracle application database schema, what is apps?
What is the concept of soa governance?
How many schemas we have? how many you have used?
In hierarchical structure of a database? we have write query from where we should start?
What do you understand by soa and what are the benefits of using this architecture?
q)what are the validations in sql*loader
tell me the scenarios of the independent in reports
Plz anybody send me Technical specification for AP Interface
How do you register report in oracle apps?
What is sca and how is it useful?
How can you achieve loose coupling in soa framework?
Tell me how to debug the report?
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?
Tell me where we find the status of order information?
what is pay run id ?
