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 the difference between distinct and unique in sql?

0 Answers  

---

What are the operators in sql?

0 Answers  

---

What is inner join in sql?

0 Answers  

---

What is a parameter query?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Is primary key an index?

0 Answers  

---

Why use truncate instead of delete?

0 Answers  

---

What are triggers and its uses?

0 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

What is blind sql injection?

0 Answers  

---

How do I count duplicates in sql?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---