How to use Starts With or Contains function in BI Report SQL Query
Summary:
Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how?
Content (required):
Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how?
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications 23C (11.13.23.07.0)
Code Snippet (add any code snippets that support your topic, if applicable):
select *
from po_action_history poah
where
poah.object_type_code='PO'
AND poah.action_code='COMMUNICATION'
AND poah.NOTE starts with ('EMail:')
Tagged:
0