ALTER TABLE  "PPSNEPL"."EPL_PRODUCTS" ADD (
        "RXCUI" NUMBER(30 , 0) ,
        "RX_NORM_NAME" VARCHAR2(50) ,
        "RX_NORM_SYN" VARCHAR2(50),
        "RX_NORM_TTY" VARCHAR2(50),
        "RX_NORM_LANGUAGE" VARCHAR2(3),
        "RX_NORM_SUPRESS" CHAR(1),
        "RX_NORM_UMLSCUI" VARCHAR2(50)
);

alter table ppsnepl.epl_products modify RX_NORM_NAME VARCHAR2(600);
alter table ppsnepl.epl_products modify RX_NORM_SYN VARCHAR2(600);
