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;
最新推荐文章于 2023-05-09 09:15:00 发布