We're taking a break this week as Connor and Chris will both be at CloudWorld, the premier Oracle conference of 2024. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Joel.
Asked: September 03, 2024 - 5:52 pm UTC
Last updated: September 04, 2024 - 2:28 am UTC
Version: 19c.22
Viewed 100+ times
execute immediate 'delete from emp where empno = p_my_plsql_variable';
execute immediate 'delete from emp where empno = :b1' using :new.empno;
SQL> create table t ( x int ); Table created. SQL> create or replace 2 trigger trg 3 before insert on t 4 for each row 5 declare 6 v int; 7 begin 8 execute immediate 'select count(*) from emp where empno = :b1' using :new.x; 9 end; 10 / Trigger created.
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library