Vikas Pandey, Author at Ontoor blogs

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: Copy CodeCopiedUse a different BrowserSELECT REGEXP_REPLACE ('Vikas Pandey from Delhi', '[[:blank:]]+', ' ')…

Vikas Pandey April 13, 2020

APEX

4 Ways to Open Inline Dialog Using jQuery Oracle APEX

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…

Vikas Pandey April 12, 2020

ORACLE SQL

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

To Remove New line from the string: Copy CodeCopiedUse a different BrowserDECLARE p_sting VARCHAR2 (100) := 'This is Vikas from Delhi Now the next line. '; BEGIN DBMS_OUTPUT.put_line (p_sting); DBMS_OUTPUT.put_line…

Vikas Pandey April 12, 2020

APEX

Preserve Checkbox state while Paginating in Interactive/Classic Report Oracle APEX

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…

Vikas Pandey April 11, 2020

APEX

APEX_ITEM Validation In Classic/Interactive Report Oracle APEX 5.1

Today we will learn how to raise instant error on apex item in interactive/classic report. On those cases here I have a solution on how to raise an error during…

Vikas Pandey April 6, 2020

APEX IG Interactive Grid

Set Row Pagination As Select List In Interactive Grid Oracle APEX

Set Row Pagination As Select List In Interactive Grid Oracle APEX s I have Created an Interactive Grid using the following SQL Query. select ID, NAME, LOCATION, COUNTRY from DEPARTMENTS…

Vikas Pandey April 6, 2020

APEX IG Interactive Grid

Add Custom Button To Load More Records from Interactive Grid In Oracle APEX

Add Custom Button To Load More Records from Interactive Grid In Oracle APEX Today we will learn how to add a custom button for Load more record in Interactive Grid.…

Vikas Pandey April 5, 2020

APEX

How to Add YouTube Videos on Page in Oracle APEX

Today I will tell you How to add YouTube video on apex page first open YouTube and follow screenshot. Copy and Paste below code into page region. <iframe height="403"…

Vikas Pandey April 4, 2020

APEX

How to Set Custom Login background in Oracle APEX

How Set Custom Login background in Oracle APEX Oracle APEX 20.1 has given default solution for changing only background colour but sometimes user want to set his custom picture on…

Vikas Pandey April 3, 2020

APEX

How to Add Vertical/Horizontal Scroll Bar in Classic Report Oracle APEX

Today I will tell you how to add scroll bar vertical and horizontal in a classic report. I have created a classic Report with the following SQL Query: Copy CodeCopiedUse…

Vikas Pandey April 1, 2020