Answer Posted / dhana

A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the outer
query. This is the main difference between a correlated
subquery and just a plain subquery. A plain subquery is not
dependent on the outer query, can be run independently of
the outer query, and will return a result set. A correlated
subquery, since it is dependent on the outer query will
return a syntax errors if it is run by itself.

can u give guidance abt packages of plsql

2174

---

What Are Cross Validation & Adi?

1157

---

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

1312

---

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2183

---

Why more redos are generated when the oracle database is in begin backup mode?

1120

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2861

---

What is Restricted Mode of Instance Startup in Oracle?

1199

---

Explain the use of table functions.

2485

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2220

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2258

---

Where in the Oracle directory tree structure are audit traces placed?

2637

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7670

---

What view would you use to determine free space in a tablespace?

2224

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

2022

---

What is the mandatory setup in cyclecount ?

2751

---