--THIS FILE IS NEEDED ONLY FOR THE ONLINE UPDATE OR WHEN UPGRADING FROM VERSION 8.8.2.4!!!

CREATE TABLE WSCT_UPD AS (SELECT WSCT_ID AS UPD_ID,  SUBSTR(LONG_TO_CHAR( ROWID, 'WSCT', 'WSCT_TEXT'), 1, 30) AS UPD_DESCRIPTION FROM WSCT WHERE WSCT_DESCRIPTION IS NULL);

UPDATE WSCT SET WSCT_DESCRIPTION = (SELECT UPD_DESCRIPTION FROM WSCT_UPD WHERE WSCT_ID=UPD_ID) WHERE  WSCT_DESCRIPTION IS NULL;

DROP TABLE WSCT_UPD CASCADE CONSTRAINTS;
