You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

How to add Sub query as a field in PS Query?

1 reply [Last post]
Rajendra Prasad's picture
User offline. Last seen 3 years 5 weeks ago. Offline
Joined: 08/08/2011
Posts: 7

I want to use a sub query as a field in PS Query.. How to do this??

Ex: Select emplid,empname,(select sysdate from dual) from employee;

Raj

Rajendra Prasad's picture
User offline. Last seen 3 years 5 weeks ago. Offline
Joined: 08/08/2011
Posts: 7
Re: How to add Sub query as a field in PS Query?

Got the Answer...

1) create an sql object with the query
2) create Expression using %sql construct (Ex: %sql(Objct Name) )
3) add that expression as a field.

http://peoplesoft-search.blogspot.in/2014/03/making-sub-query-as-field-in-ps-query.html

Raj

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
6 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.