Answer / lara

SELECT column FROM table
WHERE ROWNUM <= 10

Answer / karthik

select * from emp
where rownum <=10;

or

select * from (select rownum r,emp.* from emp)
where
r between 1 and 10;

Answer / sunil

select * from emp where rownum<=10;

or

select * from (select rowid ri,e.* from emp e order by ri)
where ri<=10;

Answer / prachi

select TOP(10) from emp
orderby empid

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

0 Answers   TCS,

---

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

---

What is cardinality?

4 Answers  

---

why r u using etl tool.

2 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

What are different types of transactions in ar? : oracle accounts receivable

0 Answers  

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

0 Answers  

---

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

---

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

---

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

---

what is the difference between oracle 81,91,11i

2 Answers   i2, Oracle,

---