Skip to Main Content

SQL Developer Web

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to select the inner query's result as an output

user-h3853May 15 2023 — edited May 20 2023

How to get the inner query's column as output in the select statement? Here the lang in users table needs to be returned by the select statement. Is it possible with this query?

SELECT ID, LANG  -- THIS LANG IS NOT WORKING
INTO V_TRAVEL_ID, V_LANG
FROM TRAVEL_TABLE
WHERE USER_ID = (SELECT MYID, LANG -- this LANG column needs to be returned from the query
                 FROM USERS
                 WHERE CONTACT_ID = V_CONTACT_ID);
Comments
Post Details
Added on May 15 2023
1 comment
272 views