SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; You might Like How to Remove New line from a String Using PL/SQL/ORACLE Read more
In this article, you can learn how to open an inline modal dialog in Oracle Apex. There are different ways to open modal dialog using simple JQuery. Inline modal dialog helps us in critical situations such as showing an error... Read more
How to create Pipelined Functions in Oracle? Pipeline functions are used to return data in tabular format. It returns the data in the nested table type. Pipeline functions are useful to dump data derived from the complex queries. Read more
Someone has asked this question to me how can we preserve checked checkboxes in the session state.This Problem will come when the user checks a few checkboxes and goes to the next set of rows via pagination in the report... Read more
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. Item Setting: Page Action on Selection: Submit... Read more
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... Read more
How to display multiple columns in APEX POP UP LOV? Legacy APEX POP UP LOV generally has one display column and one return column. What if we need to display more information to the user to search on. APEX Version... Read more
Working with Oracle and APEX it’s not necessary to keep all the data in the one system. Say you need all the details data in one place and all transaction data in one place, we need DB links or synonyms... Read more
How to Add new region position in APEX login page? APEX has been upgraded it login templates all the way from simple region to login template region then in APEX it is also available with split design. Since I have... Read more