Skip to Main Content

SQL & PL/SQL

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!

Input Parameter and SUBSTR

User_BX221Sep 26 2022

When I use in WHERE clause SUBSTR(:InputParameter, 1, 5) it works only if there is only one match in the db. If there are more than one matches it fails to execute. Is there another way to use a combination of SUBSTR and :InputParameter in plain SQL so as to avoid using PL/SQL?

Comments
Post Details
Added on Sep 26 2022
8 comments
496 views