Ever wanted to find strings which contain Quote character. Using CHR(39) is the way.
Ex:
select table_name||CHR(39) from all_tables where table_name like '%'||CHR(39)||'%'
and rownum < 5;
I am here trying to find table names which contain a quote char.
Subscribe to:
Post Comments (Atom)
Integrations Lead - Lessons learnt
Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...
-
For most outbound interfaces bursting to content server and then picking the file from UCM is the best approach for large extracts. Default...
-
While developing Cloud integrations I could not find a single place for all details like InterfaceID or jobdefinitionname or job name etc. ...
-
You can use valueset(Ex-ORG_LEVEL1) to use the query table functionality in Fast Formulas. Below is sample how you pass parameters(P_ORG_ID)...
No comments:
Post a Comment