Is it possible to use LOCATE(), or a similar function, with wildcards?
For example, if i'm searching in a string for '%N.___.3__%'. Is it possible to use an existing function to find and extract the value using SUBSTRING()?
LOCATE doesn't support wildcards like the LIKE operator does in SQL with '_' and '%'.
LOCATE
LIKE
And I don't remember any regular expression string function in LSQL. Depending what you are trying to do, if a regex is what you need, you will need to consider pushing that down to your database if that's possible.
the example in this link might help
https://forums.oracle.com/ords/apexds/post/how-to-use-locate-function-if-multiple-occurences-of-same-c-7128
Adding as extension to the lack of wildcards or regexp on LSQL, you can translate a '%N.__.3__%' into a series if LOCATE, SUBSTRING, If-Else conditions. It will be ugly, difficult to maintain and even more to explain what it does over time. And you better not have such kind of expression applied to more than a few rows, because you will pay a huge performance tax. That's why a quickwin could be EVALUATE to push to the database the job (it has more functions that can do the job better than LSQL), or ideally directly in the database as an integration step before to report and analyse data.
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
