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 are the forced views

6 Answers   Hexaware, TCS,

---

what is 'mysqlcheck'? : Sql dba

0 Answers  

---

What is blind sql injection?

0 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

what is difference between delete and truncate commands? : Sql dba

0 Answers  

---

What is package in pl sql with an examples?

0 Answers  

---

What is pl sql collection?

0 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

Can cursors be part of a trigger body?

0 Answers  

---

Compare SQL and PL/SQL.

3 Answers  

---