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 stored procedure? : Sql dba

0 Answers  

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

How many sectors are in a partition?

0 Answers  

---

What is pl sql block in dbms?

0 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What is Difference Between Unique and Primary Key Constraints?

0 Answers   Wipro,

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---

Which command is used to delete a package?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---

what is not null constraint? : Sql dba

0 Answers  

---

What is the main difference between sql and pl/sql?

0 Answers  

---