Interested to Buy Any Domain ? << Click Here >> for more details...
what is the querry to get first 10 records from the emp
table?(emp no is the primary key)
- 4 Answers
- 7951 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / sunil
select * from emp where rownum<=10;
or
select * from (select rowid ri,e.* from emp e order by ri)
where ri<=10;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the tools used for oracle 10g in real time.
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
what is the link between suppliers and banks in ap module in oracle apps? And also query?
HOW TO SPOT AHIERARCHY?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar
please send me oracle pl/sql exp resume. and also faqs...
How would you determine who has added a row to a table?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
