Total Pageviews

January 17, 2016

1/17/2016 02:14:00 AM
SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ITEMDESC',2,'VARCHAR2',100,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ITEMCOST',3,'NUMBER',9,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','CREATED_BY',4,'NUMBER',8,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','CREATION_DATE',5,'DATE',11,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','LAST_UPDATED_BY',6,'NUMBER',8,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','LAST_UPDATE_DATE',7,'DATE',11,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE_CATEGORY',8,'VARCHAR2',150,'N','Y')
;

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE1',9,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE2',10,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE3',11,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL>  EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE4',12,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE5',13,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> COMMIT;

Commit complete.

0 comments:

Post a Comment