PL/SQL Dynamic SQL - Oracle Documentation

PL/SQL provides two ways to write dynamic SQL: Native dynamic SQL, a PL/SQL language (that is, native) feature for building and running dynamic SQL ...

docs.oracle.com