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


Please Help Members By Posting Answers For Below Questions

What is Restricted Mode of Instance Startup in Oracle?

671


Why more redos are generated when the oracle database is in begin backup mode?

657


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1618


What is db_recovery_file_dest in oracle? When do you need to set this value?

644


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1982






What do you mean by Oracle MEDIA RECOVERY?

721


How would you determine what sessions are connected and what resources they are waiting for?

1610


Explain the process of recievables in oracle financials. : oracle accounts receivable

654


Give two methods you could use to determine what DDL changes have been made.

6013


Are These Dff's Flexible?

731


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

726


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.

1624


can u give guidance abt packages of plsql

1644


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?

1916


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1769