20230830 - 감사 Audit 컬럼

-- create tables

create table tbl_a (

    id                             number generated by default on null as identity 

                                   constraint tbl_a_id_pk primary key,

    col_a                          varchar2(4000 char),

    col_b                          varchar2(4000 char),

    created                        date not null,

    created_by                     varchar2(255 char) not null,

    updated                        date not null,

    updated_by                     varchar2(255 char) not null

)

;

-- triggers

create or replace trigger tbl_a_biu

    before insert or update 

    on tbl_a

    for each row

begin

    if inserting then

        :new.created := sysdate;

        :new.created_by := coalesce(sys_context('APEX$SESSION','APP_USER'),user);

    end if;

    :new.updated := sysdate;

    :new.updated_by := coalesce(sys_context('APEX$SESSION','APP_USER'),user);

end tbl_a_biu;

/

-- load data

 

-- Generated by Quick SQL Wednesday August 30, 2023  09:18:34

 

/*

tbl_a

  col_a

  col_b

# settings = { semantics: "CHAR", auditCols: true, language: "EN", APEX: true }

*/