Even in Oracle 10g, there is no such command. I've been watching native dynamic SQL for a long time, and I still find that it's not as powerful as DBMS_SQL in these cases.

Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

Oracle ORCL rolled out its latest offering — Oracle Dynamic Skills — to enable businesses to gain a thorough understanding of their employees’ skill sets as well as help staff to upskill. Oracle ...