FAQ Database Discussion Community

like and regexp_like

For like we have %. for ex: if we give ad% it ll fetch all the records which starts with ad but i should use regexp_like. for regexp_like what can be used so that it acts as % for like. i cant use ^ad because from UI we ll give...

Exclude numeric values from report

I have a field named statu in the table TB_ORDERS. If the field status has a numeric value, I should exclude that record from report - only alphabetical should be shown. How do I do that?...

How to use Regex_Like for this case?

I have a field named Order_ID from table Order. when value of Order_ID starts with numeric value then it should exclude those records, otherwise it should include those records in the report. For example: if the Order_ID starts with a value 1ABC it should exclude that record from report ....