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'

How to list all tables in your schema?

0 Answers  

---

Define Normalization with example?

1 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

0 Answers  

---

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

---

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

---

How to download oracle database 10g xe?

0 Answers  

---

What is query image?

0 Answers  

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

How to use subqueries in the from clause in oracle?

0 Answers  

---

Explain the use of online redo log files in oracle.

0 Answers  

---

Difference between inner join vs where ?

0 Answers  

---