Answer Posted / 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

What is informix sql?

1028

---

What steps server process has to take to execute an update statement?

1016

---

What is the difference between clustered and non-clustered indexes?

1126

---

What is exit statement?

1059

---

List the different type of joins?

1113

---

Describe types of sql statements?

1102

---

How to select unique records from a table?

1105

---

State some properties of relational databases?

1112

---

how to enter characters as hex numbers? : Sql dba

1102

---

What is the most common sql injection tool?

1086

---

What is percent sign in sql?

1324

---

Is sqlite free?

1022

---

Can we insert data into materialized view?

989

---

Is full outer join same as cross join?

1013

---

How many sql statements are used? Define them.

1076

---