Answer Posted / roshan

ONE THING I WOULD LIKE TO TELL.. SUBQUERY RUNS MUCH FASTER
THAN CO-RELATED QUERY..
BECAUSE EACH TIME IT HAS TO COMPARE THE OUTER QUERY IS
EVALUATED EACH TIME............

How to drop an existing table in oracle?

1058

---

How to use "for" statements in oracle?

1076

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1884

---

How to pass a cursor variable to a procedure?

1109

---

defination of bitmap index

2126

---

What are the various constraints used in oracle?

1046

---

Is oracle a programming language?

989

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2275

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2103

---

What is index-organized table in Oracle?

1069

---

Where is the export dump file located?

1158

---

How to use subqueries with the in operator using oracle?

1091

---

How to use like conditions in oracle?

1056

---

How to set up autotrace for a user account?

1059

---

How to get a list of all background sessions in the database?

993

---