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

How do you resize a data file?

2 Answers  

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,

---

What is cardinality?

4 Answers  

---

what are the API of GL,PO,AP

0 Answers  

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

---

the user should know to which database he is connected currently in oracle

3 Answers  

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

0 Answers  

---

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers  

---

what is the difference b/w oracle8i and oracle9i

3 Answers   iGate,

---