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!

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?

Added on Sep 28 2023

#database-installation, #database-upgrade, #general-database-discussions, #heterogeneous-connectivity, #plsql, #sql, #sqldeveloper, #sqlplus

3 comments

326 views