在表中插入列_2008年1月18日13点34分

      数据库 2008-1-18 13:38

-- Start of DDL Script for Table AAS.GPASFMTAB
-- Generated 2008-01-15 17:20:56 from AAS@DEVDB.HAIERNEWYORKLIFE.COM.CN

ALTER TABLE gpasfmtab add
    (
     agtfmt                         NUMBER(10,0),
     appagt                         NUMBER(10,0),
     appmgrt                        NUMBER(10,0),
     actagt                         NUMBER(10,0),
     actsmt                         NUMBER(10,0),
     actmpt                         NUMBER(10,0),
     mgrtfat                        NUMBER(10,0),
     mgrtfmt                        NUMBER(10,0)
    )
/

alter table ams_gpatab add
    (
     ytdattagt                      NUMBER(10,0),
     ytdappagt                      NUMBER(10,0),
     score9                         NUMBER(8,2)   
    )

-- End of DDL Script for Table AAS.GPASFMTAB

标签集:TAGS:SQL PL/SQL Alter
回复Comments() 点击Count()

回复Comments

{commentauthor}
{commentauthor}
{commenttime}
{commentnum}
{commentcontent}
作者:
{commentrecontent}