How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com
Regards
Arun
Answer Posted / fahad
select * from emp where rownum<=8
minus
select * from emp where rownum<=7
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Where in the Oracle directory tree structure are audit traces placed?
please send me oracle pl/sql exp resume. and also faqs...
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Why more redos are generated when the oracle database is in begin backup mode?
A scenario for amount correction & how to use amount correction functionality in AP invoices
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
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.
How would you determine who has added a row to a table?
What do you mean by hz_ in customer tables? : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is Tax Categories?
What is supporting issues GL AP and AR?
what is difference between inner join & nested query or subqueries
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable