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

Why triggers are used?

936

---

What are commit, rollback, and savepoint?

938

---

What is error ora-01000: maximum open cursors exceeded

1060

---

What is the best free sql database?

999

---

How to read/write files from pl/sql?

992

---

What is the importance of sqlcode and sqlerrm?

1276

---

Show how functions and procedures are called in a pl/sql block.

1041

---

What is rtm stands for?

1020

---

What mean sql?

950

---

What are the uses of sysdate and user keywords?

1050

---

what is transaction? : Sql dba

959

---

Which operator is used in query for pattern matching?

1031

---

Can a foreign key have a different name?

888

---

what are the advantages and disadvantages of views in a database? : Sql dba

993

---

What are the popular database management systems in the it industry?

925

---