Answer / nishi

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

Answer / basanti

select * from emp where emp_id between '200' and '300'

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 Answers   IBM, Wipro,

---

What is dictionary cache ?

2 Answers  

---

does the query needs a hint to access a materialized view?

1 Answers  

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

Whether any commands are used for months calculation? If so, what are they?

0 Answers  

---

What is control file used for?

0 Answers  

---

How to create an initialization parameter file?

0 Answers  

---

How to use "in" parameter properly?

0 Answers  

---

What is an oracle database table?

0 Answers  

---

What are ACID properties in databases?

1 Answers  

---