Dynamic SQL Core
uAbout 90% of dynamic SQL is covered by a single command (with variations):
u
udeclare
u   v_variable_tx varchar2(32000);
ubegin
u   v_variable_tx:='whatever_you_want';
u   EXECUTE IMMEDIATE v_variable_tx;
uend;
u              OR
ubegin
u   EXECUTE IMMEDIATE 'whatever_you_want';
uend;