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;

How can you enable a trace for a session?

2 Answers  

How can you rebuild an index?

1 Answers  

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

How do you add a data file to a tablespace?

1 Answers  

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers   Logisoft,

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

0 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,

please send me oracle pl/sql exp resume. and also faqs...

0 Answers  

What is auto invoicing? Explain : oracle accounts receivable

0 Answers  

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

Compare and contrast TRUNCATE and DELETE for a table.

3 Answers