Skip to Main Content
Forums

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!

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.

Oracle SQL/PL-SQL - Check if certain values exist in the String

Sunil KumarAug 24 2022

DB Version: 19c
EBS: R12.2.9
Dear All,
Table: Product
Col Name: Product_NAME
Value in Col:
0101-34551:Bucket Tire and Fax/514 USD*9991-10006:Sound Access/66 USD
0101-34551:Bucket Tire and Fax/514 :Credit Access/66 USD
0101-34551:Bucket Tire and Fax/514 USD*9991-10006:66 USD
----------
There is a AR lookup defined with certain values.
e.g.
Sound Access
Memo Random
Credit Access
-------------
Condition to be met:
Case-1
If the Product name has a value of %Bucket Tire and Fax% only (apart from lookup values) then, should show - "New Bucket Booking"
E.g.0101-34551:Bucket Tire and Fax/514 USD*9991-10006:66 USD
Case-2
If the Product name has a value of %Bucket Tire and Fax% and value exist in lookup %Sound Access% then, should show - "New Method Booking"
E.g.0101-34551:Bucket Tire and Fax/514 USD*9991-10006:Sound Access/66 USD
How to attain this.
Appreciate your help in this regard.
Thank you!
SG
This post has been answered by Sunil Kumar on Aug 25 2022
Jump to Answer

Comments

Processing

Post Details

Added on Aug 24 2022
#pl-sql, #sql, #sqlplus
16 comments
5,878 views
1 mention