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

what is diff between pre insert,on insert,post insert triggers?

1 Answers   IRISA,

---

When the procedures or packagess become invalidate

3 Answers   TCS,

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

0 Answers  

---

Explain how to close periods in ar. : oracle accounts receivable

0 Answers  

---

What is an Oracle database Partial Backup?

0 Answers  

---

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

---

What view would you use to look at the size of a data file?

1 Answers  

---

Difference between transaction type and transaction sources. : oracle accounts receivable

0 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 Answers  

---