Answer / chaitanya.s

retrieving 8th record from emp table in scott instance

select * from emp where rownum<=8
minus
select * from emp where rownum<=7

Answer / fahad

select * from emp where rownum<=8
minus
select * from emp where rownum<=7

Answer / shaibya sandeep dwivedi

select id,salary from (select rownum as t,id,salary from
emp) where t=8;

Answer / raj

select * from (select a.*, rownum as n from temp_table a)
where n = 8

Answer / sandeep

syntax: select <rownum>,<c.. n.. 2>,<c..n..3>
from<tablename>
group by<rownum>,<c.n.2>,<c.n.3>
having rownum=&n
eg:
select rownum,ename,empno from emp
group by rownum,ename,empno
having rownum=&8

Answer / raam

Hi, above both the answers not worked..

Answer / raj

select rownum,ename,address from emp where rownum=8;

Answer / hitesh rathod

or we can directly use
select * from emp where rownum=8;

What view would you use to determine free space in a tablespace?

1 Answers  

what are the API of GL,PO,AP

1 Answers  

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1 Answers   Accenture,

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

1 Answers   Punjab National Bank,

deference between & and &&

2 Answers   Mphasis,

What is the disk migration? what is the steps involved in oracle disk migration?

1 Answers  

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

What is database schema?

4 Answers   Infosys,

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.

1 Answers  

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

Give the reasoning behind using an index.

2 Answers