alter table SDC_INDEXQUOTE add SECURITYID1 INTEGER;
update SDC_INDEXQUOTE set SECURITYID1 = TO_NUMBER(SECURITYID);
alter table SDC_INDEXQUOTE drop column SECURITYID;
alter table SDC_INDEXQUOTE RENAME COLUMN SECURITYID1 to SECURITYID;
create index I_SDCINDEXQUOTE01 on SDC_INDEXQUOTE (securityid, tradedate);
RENAME COLUMN SECURITYID1 to SECURITYID;
最新推荐文章于 2021-04-08 21:36:11 发布