SQL Language (MOSC)

MOSC Banner

Error adding a virtual column to a table

edited Jun 7, 2013 9:26AM in SQL Language (MOSC) 4 commentsAnswered
SQL> desc event_audit_t_bak;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OBJ_ID0                                            NUMBER(38)
 REC_ID                                             NUMBER(38)
 OBJECT_DB                                          NUMBER(38)
 OBJECT_ID0                                         NUMBER(38)
 OBJECT_TYPE_NAME                                   VARCHAR2(255)
 OBJECT_REV                                         NUMBER(38)
 OBJECT_TYPE_ID                                     NUMBER(38)
 OBJECT_TYPE                                        VARCHAR2(255)

SQL> ALTER TABLE event_audit_t_bak ADD (account_obj_DB int , account_obj_ID0 int , account_obj_TYPE_ID int, account_obj_TYPE generated always as (SUBSTRB(PIN_VIRTUAL_COLUMNS.GET_OBJECT_NAME(account_obj_TYPE_ID),0,255)) virtual , account_obj_REV int );
ALTER TABLE event_audit_t_bak ADD (account_obj_DB int , account_obj_ID0 int , account_obj_TYPE_ID int, account_obj_TYPE generated always as (SUBSTRB(PIN_VIRTUAL_COLUMNS.GET_OBJECT_NAME(account_obj_TYPE_ID),0,255)) virtual , account_obj_REV int )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center