Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE /*ADMIN.*/ACCT_HRS(
  WID            NUMBER,
  HOURS_TYPE_CD  NUMBER,
  WRK_DT         DATE,
  TECH_ID        NUMBER,
  TECH_TYPE      VARCHAR2(20),
  TECH_CLASS     VARCHAR2(200),
  MAN_HRS        NUMBER,
  JOB_ORDER      NUMBER,
  CREATE_DT      DATE,
  EUSER_ID       NUMBER,
  MAN_HRS_SEQ_NO NUMBER
)
CREATE TABLE /*ADMIN.*/INVENTORY(wid, pknum) AS
SELECT 1, '&pknum' FROM DUAL;
1 rows affected

INSERT INTO /*ADMIN.*/ACCT_HRS (WID, HOURS_TYPE_CD, WRK_DT, TECH_ID, TECH_TYPE, TECH_CLASS, MAN_HRS, JOB_ORDER, CREATE_DT, EUSER_ID, MAN_HRS_SEQ_NO)
SELECT 1, 2, DATE '1970-01-01', 3, 'ABC', 'DEFGHI', 4, 5, SYSDATE, 6, 7 FROM DUAL UNION ALL
SELECT 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM DUAL;
2 rows affected

SELECT 'INSERT INTO ADMIN.ACCT_HRS (WID, HOURS_TYPE_CD, WRK_DT, TECH_ID, TECH_TYPE, TECH_CLASS, MAN_HRS, JOB_ORDER, CREATE_DT, EUSER_ID, MAN_HRS_SEQ_NO) VALUES ('
    || COALESCE( TO_CHAR(wid), 'NULL') || ','
    || COALESCE( TO_CHAR(hours_type_cd), 'NULL') || ','
    || CASE
       WHEN wrk_dt IS NULL THEN 'NULL'
       ELSE 'TO_DATE(''' || TO_CHAR(wrk_dt, 'SYYYY-MM-DD HH24:MI:SS') || ''', ''SYYYY-MM-DD HH24:MI:SS'')'
       END || ','
    || COALESCE( TO_CHAR(tech_id), 'NULL') || ','
    || CASE WHEN tech_type IS NULL THEN 'NULL' ELSE '''' || tech_type || '''' END || ','
    || CASE WHEN tech_class IS NULL THEN 'NULL' ELSE '''' || tech_class || '''' END || ','
    || COALESCE( TO_CHAR(man_hrs), 'NULL') || ','
    || COALESCE( TO_CHAR(job_order), 'NULL') || ','
    || CASE
       WHEN create_dt IS NULL THEN 'NULL'
       ELSE 'TO_DATE(''' || TO_CHAR(create_dt, 'SYYYY-MM-DD HH24:MI:SS') || ''', ''SYYYY-MM-DD HH24:MI:SS'')'
       END || ','
    || COALESCE( TO_CHAR(euser_id), 'NULL') || ','
    || COALESCE( TO_CHAR(man_hrs_seq_no), 'NULL')
    || ')' AS sql
FROM   /*ADMIN.*/ACCT_HRS
WHERE  WID IN ( SELECT WID
                FROM   /*ADMIN.*/INVENTORY
                WHERE  pknum = '&pknum' );


SQL


INSERT INTO ADMIN.ACCT_HRS (WID, HOURS_TYPE_CD, WRK_DT, TECH_ID, TECH_TYPE, TECH_CLASS, MAN_HRS, JOB_ORDER, CREATE_DT, EUSER_ID, MAN_HRS_SEQ_NO) VALUES (1,2,TO_DATE(' 1970-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'),3,'ABC','DEFGHI',4,5,TO_DATE(' 2024-03-27 10:16:12', 'SYYYY-MM-DD HH24:MI:SS'),6,7)

INSERT INTO ADMIN.ACCT_HRS (WID, HOURS_TYPE_CD, WRK_DT, TECH_ID, TECH_TYPE, TECH_CLASS, MAN_HRS, JOB_ORDER, CREATE_DT, EUSER_ID, MAN_HRS_SEQ_NO) VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)


INSERT INTO /*ADMIN.*/ACCT_HRS (WID, HOURS_TYPE_CD, WRK_DT, TECH_ID, TECH_TYPE, TECH_CLASS, MAN_HRS, JOB_ORDER, CREATE_DT, EUSER_ID, MAN_HRS_SEQ_NO) VALUES (1,2,TO_DATE(' 1970-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'),3,'ABC','DEFGHI',4,5,TO_DATE(' 2024-03-27 10:15:18', 'SYYYY-MM-DD HH24:MI:SS'),6,7)
1 rows affected

INSERT INTO /*ADMIN.*/ACCT_HRS (WID, HOURS_TYPE_CD, WRK_DT, TECH_ID, TECH_TYPE, TECH_CLASS, MAN_HRS, JOB_ORDER, CREATE_DT, EUSER_ID, MAN_HRS_SEQ_NO) VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
1 rows affected

SELECT *
FROM   /*ADMIN.*/ACCT_HRS


WID
HOURS_TYPE_CD
WRK_DT
TECH_ID
TECH_TYPE
TECH_CLASS
MAN_HRS
JOB_ORDER
CREATE_DT
EUSER_ID
MAN_HRS_SEQ_NO


1
2
1970-01-01 00:00:00
3
ABC
DEFGHI
4
5
2024-03-27 10:16:12
6
7

1
null
null
null
null
null
null
null
null
null
null

1
2
1970-01-01 00:00:00
3
ABC
DEFGHI
4
5
2024-03-27 10:15:18
6
7

1
null
null
null
null
null
null
null
null
null
null

WID	HOURS_TYPE_CD	WRK_DT	TECH_ID	TECH_TYPE	TECH_CLASS	MAN_HRS	JOB_ORDER	CREATE_DT	EUSER_ID	MAN_HRS_SEQ_NO
1	2	1970-01-01 00:00:00	3	ABC	DEFGHI	4	5	2024-03-27 10:16:12	6	7
1	null	null	null	null	null	null	null	null	null	null
1	2	1970-01-01 00:00:00	3	ABC	DEFGHI	4	5	2024-03-27 10:15:18	6	7
1	null	null	null	null	null	null	null	null	null	null