Skip to Main Content

Oracle Forms

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!

Pre-Query / Post-text formatting - is it possible

All

I have a request from a client who wishes to be able to paste multiple items into a query before performing Execute Query.

The intention is that the User enters the following (or pastes it from a spreadsheet - each value separated by a CR):

100ABC
101FCD
102DEF
103ABC
104AED

Before or during the Execute Query, the actual Query passed is this:

:a IN ('100ABC','101FCD','102DEF','103ABC','104AED')

Is this possible?

Regards

Richard

This post has been answered by juliojgs on Oct 4 2023
Jump to Answer
Comments
Post Details
Added on Oct 3 2023
8 comments
324 views