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 sql and t-sql? : Transact sql

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

What are the parts of a basic sql query?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

Can a table contain multiple primary key’s?

0 Answers  

---

How do I debug a stored procedure?

0 Answers  

---

What pl/sql package consists of?

0 Answers  

---

Give the structure of the function ?

2 Answers  

---

What is difference between db2 and sql?

0 Answers  

---

How to find last day of the month in sql query

4 Answers  

---

What is cross join example?

0 Answers  

---

How to write a query to show the details of a student from students table whose

0 Answers  

---