Before discussing dynamic SQL in detail, a clear definition of static SQL may provide a good starting point for understanding dynamic SQL.
Simultaneously, Oracle makes permanent or undoes all database changes made by a transaction.
You may not always know the full text of the SQL statements that must be executed in a PL/SQL procedure.
create or replace procedure student Load is v_id ID%type; v_name Name%type; v_sn stud Name%type; cursor cur_load is select * from student; begin open cur_load; loop fetch cur_load into v_id,v_name; exit when cur_load%notfound; select stud Name into v_sn from stud Load where stud ID = v_id; if(v_sn!
You could create a trigger on table B that updates table A every time field_2 on table B is updated.
Samuel Johnson This chapter helps you harness the power of Oracle.