Answer Posted / sreekumar

A scalar query returns exactly one column value from one row.

If it returns 0 rows, then the value scalar query is NULL. If returns more than one row, then Oracle returns an error.

eg.
select first_name, last_name,
(select job_title
from jobs
where employees.job_id = jobs.job_id) job_title
from employees
where rownum < 5;


Note :Use this method only as your last option in the coding..:) performance wise this is bad.

-Sreekumar
Oracle 10g DBA

What is a null value?

1125

---

Why do we need unique key in a table?

942

---

What are crud methods?

1015

---

What is procedure function?

1041

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1093

---

What is a .db file?

961

---

How do you delete duplicates in sql query using rowid?

928

---

what is 'mysqlimport'? : Sql dba

1019

---

What is a design view?

916

---

Why is stored procedure faster than query?

935

---

Which is better stored procedure or query?

949

---

How do I tune a sql query?

959

---

What is a unique constraint?

1060

---

Can I create table without primary key?

982

---

How to know the last executed procedure?

1071

---