摘要:
转自:http://space.itpub.net/10678339/viewspace-522818create table TEST( ID NUMBER not null, NAME VARCHAR2(20))ALTERTABLESCOTT.TESTRENAMETOTEST1--修改表名ALTERTABLESCOTT.TESTRENAMECOLUMNNAMETONAME1 --修改表列名ALTERTABLESCOTT.TESTMODIFYNAME1NUMBER(20) --修改字段类型ALTERTABLESCOTT.TESTADDADDRESSVARCHAR2(40)--添加表列ALTE 阅读全文