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

Does group by remove duplicates?

0 Answers  

---

Is sql a case sensitive language?

0 Answers  

---

What is sqlca in db2?

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

what is the use of set statement in tsql? : Transact sql

0 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

---

describe transaction-safe table types in mysql : sql dba

0 Answers  

---

What is the command used to fetch the first 5 characters of a string?

0 Answers  

---

what the meaning of sql

8 Answers  

---

Does mysql_real_escape_string prevent sql injection?

0 Answers  

---

How do I find duplicates in the same column?

0 Answers  

---