Skip to Main Content
Forums

SQL & PL/SQL

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!

I want to alter table with virtual columns assciated expression with it, need guidance

Ora_DB_LearnerApr 10 2014 — edited Apr 11 2014

Hi All,

        Below is the table structure with two highlighted virtual columns expression associated, Now i want remove these expressions with virtual columns (But have to keep my columns VIRTUAL as it is).

        Can this be done by Alter statement or i need to take back up of table, make a new structure and do copy back contents to newly structured table.......Pleae help!!!!

  

  CREATE TABLE TEST_COL(

    SAGE_TRADE_TYPE                          VARCHAR2(50 BYTE),

    LOCAL_TZ                                          VARCHAR2(20 BYTE),

    GMT_CONV_ENTERED_DT_TS      AS (SAGEDBO.FN_CONVERT_TIMEZONE(LOCAL_TZ,ENTERED_DT_TS)) VIRTUAL,

    GMT_CONV_EXECUTION_DT_TS    AS (SAGEDBO.FN_CONVERT_TIMEZONE(LOCAL_TZ,UPSTREAM_EXECUTION_TS)) VIRTUAL,

    EOD_IND                                             VARCHAR2(10 BYTE)

                                              );

Many Thanks,

Arpit
This post has been answered by Karthick2003 on Apr 10 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2014
Added on Apr 10 2014
10 comments
507 views