Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 8th person record in a table?
Plz mail ur answers to
mak2786@gmail.com
Regards
Arun
- 8 Answers
- 10568 Views
- I also Faced
- E-Mail Answers
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
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Give two methods you could use to determine what DDL changes have been made.
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is the mandatory setup in cyclecount ?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the difference between recovery and restoring of the oracle database?
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?
can u give guidance abt packages of plsql
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.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
What view would you use to determine free space in a tablespace?
how to replace not in with not exist?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
