what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
Answer Posted / karthik
select * from emp
where rownum <=10;
or
select * from (select rownum r,emp.* from emp)
where
r between 1 and 10;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Explain the process of recievables in oracle financials. : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
where the dff data will be stored
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Explain prerequisites and post activities of oracle database installation
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
HOW TO SPOT AHIERARCHY?
what are the API of GL,PO,AP
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?