Dynamic SQL in Oracle 8i

Oracle 8I gives developers a new feature to allow execution of native dynamic SQL. This is an alternative to the DBMS_SQL package previously required. Now developers can use dynamic SQL in their PL/SQL procedures by using the EXECUTE IMMEDIATE statement. The following syntax provides this functionality:

 EXECUTE IMMEDIATE

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: