DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL
This video is out of audio and video sync, please find the Synced video uploaded on
Always thought we cannot have a create statement inside a pl/sql block, well here is the answer for that, and along with that learn how to generate sql statement on the go.
This video demonstrates the use of Dynamic SQL with the help of Execute Immediate. The video also demonstrates the INTO and USING clause of the execute immediate statement.
