How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com
Regards
Arun
Answer Posted / chaitanya.s
retrieving 8th record from emp table in scott instance
select * from emp where rownum<=8
minus
select * from emp where rownum<=7
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is Restricted Mode of Instance Startup in Oracle?
Why more redos are generated when the oracle database is in begin backup mode?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is db_recovery_file_dest in oracle? When do you need to set this value?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
What do you mean by Oracle MEDIA RECOVERY?
How would you determine what sessions are connected and what resources they are waiting for?
Explain the process of recievables in oracle financials. : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
Are These Dff's Flexible?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
can u give guidance abt packages of plsql
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE