Page Comparison

--Transaction Log: 18 June 2020 @ 0725
--insert into ssb.bm001_bulletin Rows affected: 1
--SQL:
DECLARE
str_v_bulletin_cd VARCHAR2(10) := '16/2020';
str_v_bulletin_title_enm VARCHAR2(255) := 'Hazards and Risks of Girding During Towing Operations';  -- update this value
str_v_bulletin_title_fnm VARCHAR2(255) := 'Dangers et risques liés à l`engagement pendant les opérations de remorquage';  -- update this value
str_v_replacement_bulletin_cd VARCHAR2(10) := null;  -- update this value
dte_v_date DATE := TO_DATE('2020-06-05', 'yyyy-mm-dd');  -- update this value
num_v_archived_ind NUMBER(1) := 0;  -- update this value

BEGIN
insert into ssb.bm001_bulletin
(bulletin_cd,
bulletin_title_enm,
bulletin_title_fnm,
replacement_bulletin_cd,
date_created_dte,
date_last_update_dte,
date_current_dte,
archived_ind)
values
(str_v_bulletin_cd,
str_v_bulletin_title_enm,
str_v_bulletin_title_fnm,
str_v_replacement_bulletin_cd,
dte_v_date,
dte_v_date,
dte_v_date,
num_v_archived_ind);

DBMS_OUTPUT.PUT_LINE('insert into ssb.bm001_bulletin Rows affected: ' ||
sql%rowcount); -- 1 row

--COMMIT;

END;