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 are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

0 Answers  

---

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 Answers  

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

---

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 Answers  

---

---

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

---

how to create an user in oracle 10g.please give me an example..

1 Answers  

---

HOW TO SPOT AHIERARCHY?

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---

Describe what redo logs are.

1 Answers  

---

Explain the use of table functions.

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---