Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select multiple columns in inline correlated subquery

SamBMay 27 2008 — edited May 29 2008

Is there a way to select multiple columns from an inline subquery?

e.g.

select (select cola, colb, colc, cold from a where a.colj = b.colj) from b;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2008
Added on May 27 2008
6 comments
18,715 views