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

What is a join?Explain the different types of joins?

6 Answers   Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,

---

What are the different types of dbmss?

0 Answers  

---

Can we use commit inside a trigger?

0 Answers  

---

Does truncate remove indexes?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

How do I order columns in sql?

0 Answers  

---

what is Complex index. how to create it?

2 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

Are left and right joins the same?

0 Answers  

---

What is field delimiter?

0 Answers  

---

Why is sql better than hql?

0 Answers  

---