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 many types of triggers exist in pl/sql?

0 Answers  

---

what is primary key? : Sql dba

0 Answers  

---

What are tables and fields?

0 Answers  

---

who introduced sql?

0 Answers  

---

What are the two types of cursors in pl sql?

0 Answers  

---

Explain the difference in execution of triggers and stored procedures?

0 Answers  

---

What is trigger and stored procedure in sql?

0 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

what is unique key constraint? : Sql dba

0 Answers  

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

---

What is clustered index in sql?

0 Answers  

---