Skip to Main Content
Forums

Oracle Database Discussions

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 will use function in select query

Mahendran PSep 28 2023

select * from customer_details where customers_orders IN (get_customer_order_details ('STEPHEN'));

For above query shows Null. But we have order details for this query does not work.

get_customer_order_details ('STEPHEN') – This function Output as shows more than one output. ex: 28283,02839,92829

but does not shows output in this query.

whether IN clause suported for more than one values by using function. if not , any other suggestions?

Comments

Processing

Post Details

Added on Sep 28 2023
#database-installation, #database-upgrade, #general-database-discussions, #heterogeneous-connectivity, #plsql, #sql, #sqldeveloper, #sqlplus
3 comments
276 views