Oracle Shooter

  CREATE TABLE APPS . XX_DELIVERY_DATA_TL (   ORDER_NUMBER           VARCHAR2 ( 500 BYTE),   TRX_TYPE             VARCHAR2 ( 500 BYTE) Default 'Delivery Feed' ,   VENDOR_CODE   VARCHAR2 ( 100 BYTE),   PROCESS_FLAG         VARCHAR2 ( 5 BYTE) )     select * from XX_DELIVERY_DATA_TL   INSERT INTO XX_DELIVERY_DATA_TL select   '98981210001' , 'Delivery Feed' , 'Cun Mun' , 'N'   FROM DUAL   INSERT INTO XX_DELIVERY_DATA_TL select   '98981210002' , 'Delivery Feed' , 'Vishal maga Mart' , 'N'   FROM DUAL   INSERT INTO XX_DELIVERY_DATA_TL select   '98981210003' , 'Delivery Feed' , 'India Pvt Ltd' , 'N'   FROM DUAL     --====================================================   DELETE FROM XX_DELIVERY_DATA_TL   select DISTINCT ORDER_NUMBER , TRX_TYPE , VENDOR_CODE , PROCESS_FLAG from XX_DELIVERY_DATA_TL A   se

  My Tech Channel link:- https://www.youtube.com/oracleshooter     CREATE TABLE XX_DELIVERY_DATA_TL ( ID                               NUMBER PRIMARY KEY,                         ORDER_NUMBER           VARCHAR2 ( 500 BYTE),   TRX_TYPE             VARCHAR2 ( 500 BYTE) ,   VENDOR_CODE   VARCHAR2 ( 100 BYTE),   PROCESS_FLAG         VARCHAR2 ( 5 BYTE) )     select * from XX_DELIVERY_DATA_TL   create sequence XX_DEL_SEQ   INSERT INTO XX_DELIVERY_DATA_TL select XX_DEL_SEQ .NEXTVAL, '98981210001' , 'Delivery Feed' , 'Cun Mun' , 'N' FROM DUAL   INSERT INTO XX_DELIVERY_DATA_TL select XX_DEL_SEQ .NEXTVAL, '98981210002' , 'Delivery Feed' , 'Vishal maga Mart' , 'N'   FROM DUAL   INSERT INTO XX_DELIVERY_DATA_TL select XX_DEL_SEQ .NEXTVAL, '98981210003' , 'Delivery Feed' , 'India Pvt Ltd' , 'N'   FROM DUAL   --=====================   select * from XX_DELIVERY_D

  My Tech Channel link:- https://www.youtube.com/oracleshooter     --==============Insted Of triggers ==========================   --Syntax--   CREATE OR REPLACE TRIGGER   XX_COMP_EMPLOYEE_TRG FOR   INSERT OR DELETE OR UPDATE --OF SAL ON XX_EMP COMPOUND TRIGGER   BEGIN      Executable - statements EXCEPTION    Exception- handling - statements END;     ---------- Tables -------   select * from   XX_EMP   EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-80 800   20 7499 ALLEN SALESMAN 7698 20-Feb-81 1600 300 30 7521 WARD SALESMAN 7698 22-Feb-81 1250 500 30 7566 JONES MANAGER 7839 02-Apr-81 2975