Skip to Main Content

SQL Developer Web

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on May 15 2023
1 comment
430 views