Oracle Apps Blog
Wednesday, September 16, 2015
Oracle Query to Replace Special Characters from a string
SELECT REGEXP_REPLACE('##$!%*~``$123&&!!__!','[^[:alnum:]'' '']', NULL) FROM dual
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Unix commands to get the count of files
ls -l *.rdf | wc -l
Grant script to grant Tables, Views and packages to other schema in Oracle Apps R12.2.X
From Oracle R12.2.X release we can use the below Oracle recommended API/package to give grants on objects in APPS schema exec AD_ZD.GR...
Query to find Oracle Concurrent Program Last Run Time:
SELECT DISTINCT user_concurrent_program_name, (SELECT MAX (actual_start_date) FROM APPS.FND_CONCU...
Oracle R12 SQL Query for Supplier Addresses on the Address Book Suppliers Entry/Update Screen
SELECT DISTINCT pv.segment1 vendor_number, pv.vendor_name, hps.party_site_name address_name, ...
No comments:
Post a Comment