RENAME COLUMN SECURITYID1 to SECURITYID

RENAME COLUMN SECURITYID1 to SECURITYID;

?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);