Vikas Pandey Archives - Page 8 of 10

How to Prevent Duplicate Row Interactive Gird Oracle Apex

Sometimes user wants to prevent duplicate row on that column where columns don’t have a unique Id or Primary key Identification. On those cases here, I have provided a solution…

Vikas Pandey April 23, 2020

APEX

2 Ways to Make Column nowrap Interactive Report Oracle APEX

SOLUTION 1: Column Formatting => HTML Expression: <span style="white-space:nowrap;">#COLUMN_NAME#</span> SOLUTION 2: Define region Id “regionId” and Column id “HIRE_ID” after that use following CSS: #regionId th#HIRE_ID, #regionId td[headers=HIRE_ID]{min-width:100px}

Vikas Pandey April 23, 2020

APEX

Preview an Image Before Upload Oracle APEX

Sometimes we face the requirement like how to show the image before image upload. There are some easy steps to preview images before upload. Create a blank page with two…

Vikas Pandey April 15, 2020

ORACLE SQL

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