With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one row — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one row

HI Team,

when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row.

how to reslove this we need Citizenship column ?

if any one help me how to add Citizenship in below query?

Thanks,

Ajay

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Select DISTINCT

papf.person_number,
ppnf.full_name as Name,
haou.Name Department_Name,
HDOR.DEI_ATTRIBUTE6 as Notes,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!