SAP (Documents/Screen shots/Complete Solution): [oracle-db-l] ORA-00913 Too Many Values Error

Question from sravani2k2 on Mar 22 at 1:22 AM

I'm getting error'.(ORA-00913 too many values )' while running below query in database

select the records based on condition

Eg:

select
(

case
when
exists
(
select 1
from hr.employees e,
hr.departments d
where e.department_id=d.department_id
)
then
(
select
e.employee_id,e.first_name,
d.department_name,l.location_id
from hr.employees e,
hr.departments d,
hr.locations l
where e.department_id=d.department_id
and
d.location_id=l.location_id
)
else
(
select
e.manager_id,e.phone_number,
d.department_name,l.location_id
from hr.employees e,
hr.departments d,
hr.locations l
where e.employee_id=d.department_id
and d.location_id=e.location_id
)
end
)

from hr.employees e,
hr.departments d,
hr.locations l

Please resolve the problem.

Reply to this email to post your response.

__.____._

Manage Settings | Unsubscribe | Create FAQ | Send Feedback