Answer Posted / sunil

select * from emp where rownum<=10;

or

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

How would you go about increasing the buffer cache hit ratio?

2608

---

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

2445

---

What Are Cross Validation & Adi?

1165

---

3. Steps in UAT?

2439

---

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

2527

---

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2193

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2218

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7685

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3944

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2283

---

What is autocashrule set? : oracle accounts receivable

1409

---

how to replace not in with not exist?

3744

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2005

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2297

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2334

---