Deletion 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

APEX

Delete row wise record in interactive report Oracle APEX

I was asked recently how I implemented the deleting of a row my Demo , so I thought I would post the answer here in case anyone else was curious.…

Vikas Pandey March 16, 2020

ORACLE PLSQL

PLSQL Collection Data Deletion

PLSQL collection data deletion CREATE OR REPLACE TYPE l_rec_type IS OBJECT (id NUMBER, name VARCHAR2 (1111)); / CREATE OR REPLACE TYPE l_tab_type IS TABLE OF l_rec_type; / Copy CodeCopiedUse a…

Ashish Sahay February 25, 2020