Hi,
I was following the Oracle Live SQL tutorial and I encountered the Error at line 7: PLS-00103: Encountered the symbol "/" when I attempted to run the following code I clearly copied and pasted:
create or replace trigger DEPARTMENTS_BIU
before insert or update on DEPARTMENTS
for each row
begin
if inserting and :new.deptno is null then
:new.deptno := to_number(sys_guid(),
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX');
end if;
end;
/
create or replace trigger EMPLOYEES_BIU
before insert or update on EMPLOYEES
for each row
begin
if inserting and :new.empno is null then
:new.empno := to_number(sys_guid(),
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX');
end if;
end;
/
The link to the tutorial is here: https://livesql.oracle.com/apex/f?p=590:1:13286540921559:CLEAR::1:TUTORIAL_ID,P1_SHOW_LEARN_SIDEBAR:66403703756642340425947956952870068,Y
Thanks!
ANOVA