what is SCALAR Queries?

Question Posted / rameshrevella

2 Answers
7044 Views
ITC Infotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is SCALAR Queries?..

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

Is This Answer Correct ?

2 Yes

2 No

what is SCALAR Queries?..

Answer / tannu

Irrespective of the case, scalar query is one which always
fetch same result

Is This Answer Correct ?

0 Yes

0 No

Post New Answer