Thanks for the question, Mohana Subbu Ram.
Asked: January 31, 2018 - 4:59 am UTC
Last updated: February 01, 2018 - 1:01 am UTC
Version: 11g
Viewed 10K+ times! This question is
SQL> create table scott.t ( x int, y int, z int ); Table created. SQL> select column_name from dba_tab_columns 2 where owner = 'SCOTT' 3 and table_name = 'T'; COLUMN_NAME ------------------------------ X Y Z SQL> alter table mcdonac.t add new_col int; Table altered. SQL> select column_name from dba_tab_columns 2 where owner = 'SCOTT' 3 and table_name = 'T'; COLUMN_NAME ------------------------------ X Y Z NEW_COL SQL> select column_name from dba_tab_columns as of timestamp sysdate-120/86400 2 where owner = 'SCOTT' 3 and table_name = 'T'; COLUMN_NAME ------------------------------ X Y Z
Mohana Subbu Ram M, January 31, 2018 - 10:15 am UTC
Need more information on Administration? Check out the Administrators guide for the Oracle Database