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 left join in postgresql?

1046

---

how to delete an existing column in a table? : Sql dba

1005

---

What is pl sql architecture?

959

---

Why indexing is needed?

984

---

what is auto increment? : Sql dba

1008

---

What is trigger types of trigger?

1069

---

how to check server status with 'mysqladmin'? : Sql dba

1075

---

Explain character-manipulation functions?

1133

---

How many tables can you join in sql?

957

---

explain advantages of innodb over myisam. : Sql dba

1128

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1216

---

Does truncate need commit?

944

---

What is trigger types in sql?

990

---

When is the explicit cursor used ?

1034

---

Can we commit inside a trigger?

988

---