ORACLE--基础ZSGC

引用

UPDATE ggmenu SET target='mainFrame' WHERE menuid='2012';
---------------------
delete from VSLEVEL where unittype='1' and unitcode='0100000001';
insert into VSLEVEL (UNITTYPE, UNITCODE, UNITNAME, COMCODE, COMNAME, LEVELNO, MANAGELEVEL, VALIDSTATUS, REMARK, FLAG, LEVELCODE, DISPLAYNO, UNITENAME, COMENAME)
values ('0', '01', '劳合社中国总公司', '01', '劳合社中国总公司', 1, 2, '1', null, null, '1', 1, null, null);
------------------------
alter table gppoamain modify BrokerCode varchar2(128);
-----------------------
alter table GsClientCorporate add LegalRepresentativeName
varchar2(30);
comment on column GsClientCorporate.LegalRepresentativeName
is '法定代表人姓名';
----------------
创建索引
create index idx_customer_registerTime on base_customer(registerTime);
语法：creat index 索引名（不能太长） on 表明（字段名）