Duplicate Archives - Ontoor blogs

3 Ways to Delete Duplicate Record From table in Oracle

How to delete duplicate record From table using SQL/Oracle? Create table using following script: Copy CodeCopiedUse a different BrowserCREATE TABLE TEST_EMP ( ENAME VARCHAR2(10 BYTE), DEPTNO NUMBER(2), ID NUMBER )…

Vikas Pandey June 9, 2020

ORACLE

3 Ways to Check Duplicate Record in table Oracle SQL

How to check duplicate record in table SQL/Oracle? Create table using following script: Copy CodeCopiedUse a different BrowserCREATE TABLE TEST_EMP ( ENAME VARCHAR2(10 BYTE), DEPTNO NUMBER(2), ID NUMBER ) Run…

Vikas Pandey June 5, 2020

APEX IG Interactive Grid

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

How to Create a Duplicate Record In Interactive/Classic Report Oracle APEX

How to Create a Duplicate Record In Interactive/Classic Report Oracle APEX Here is Small Tip How to Create a Duplicate Record In Interactive/Classic Report Oracle APEX. For that first wee…

Vikas Pandey March 19, 2020