Answer / 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

Answer / tannu

Irrespective of the case, scalar query is one which always
fetch same result

How to use transactions efficiently : transact sql

0 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

Define concurrency control. : Transact sql

0 Answers  

---

Is primary key an index?

0 Answers  

---

Does sql require a server?

0 Answers  

---

---

How delete a row in sql?

0 Answers  

---

What are the properties of a transaction?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---

What are pl/sql cursors?

0 Answers  

---

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

---

What is pl/sql table? Why it is used?

0 Answers  

---

Can we rollback after truncate?

0 Answers  

---