-- 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 }
*/
