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

Can a composite key be null?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

what is 'mysqld'? : Sql dba

0 Answers  

---

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---

What is a table partition?

0 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

How to pronounce postgresql?

0 Answers  

---

Explain locks? : Transact sql

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

What is bind reference and how can it be created?

0 Answers  

---

Explain constraints in sql?

0 Answers  

---