Remove Special Character and Extra Space From a String ORACLE/PLSQL

Removing special character using REGEXP:

SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL;

Remove extra spaces between string using REGEXP:

SELECT REGEXP_REPLACE ('Vikas Pandey from Delhi', '[[:blank:]]+', ' ') FROM DUAL;

How to Remove New line from a String Using PL/SQL/ORACLE

Comments

Refresh Static region DATA in Oracle APEX

How to refresh Static region data in ORACLE APEX? I have been receiving couple of queries about the static region refresh. In this article, I'll try to get through it. Background: In the Interactive and classic reports data refresh from database is done by AJAX. APEX internally calls the AJAX callback to fetch the data and refresh the report. Reports are followed by their templates, meaning the data is being fetched and merged/replaced with the report templates. Partial refresh during the report search or applying filters also uses the AJAX callback to update and refresh data. Let's try out We need one AJAX callback, One layout, one refresh event and Static Region. Create an AJAX callback Process. There are two places to create it Shared component: Application process - Point AJAX Callback Page Process: Point- AJAX Callback Page Process Application Process Process Name : GET_EMP_DATA Processing Point : AJAX Callback Process code : BEGIN APEX_JSON.initialize_clob_output; AP...

Change Language anytime in Oracle APEX

How to Change application language after login in ORACLE APEX? In the previous article , we have seen how to translate the application. But what if the user logs in and then want to change the language. Create one dialog page with a select list which holds the list of language. Item Setting : Page Action on Selection : Submit Page Create Entry in Navigation Bar as Language Go to Shared Components Navigation Bar List Desktop Navigation Bar Name as Language Choose the Icon Set the Target page of the Dialog page

Ontoor Solutions Pvt. Ltd.

Search This Blog