Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get added columns in the after DDL trigger?

zzhang-OracleDec 12 2005 — edited Dec 13 2005
As title, I want to get information, like name/type/.., about the added columns by sql statement "alter table *** add (***)" in the after ddl trigger. But looks like dba_tab_columns view doesn't include the added columns.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2006
Added on Dec 12 2005
9 comments
1,094 views