sql.oracle.PUR_CARI_T.sql Maven / Gradle / Ivy
TRUNCATE TABLE PUR_CARI_T DROP STORAGE
/
INSERT INTO PUR_CARI_T (CARI_CD,OBJ_ID,VER_NBR,CARI_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('FED','BD51DF30-34E7-B049-6861-9BEA0610A0FE',1.0,'Federal Express','Y')
/
INSERT INTO PUR_CARI_T (CARI_CD,OBJ_ID,VER_NBR,CARI_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('UPS','5A4A8B66-175C-E2E2-7F2F-2A7A4450FDC3',1.0,'UPS','Y')
/
INSERT INTO PUR_CARI_T (CARI_CD,OBJ_ID,VER_NBR,CARI_DESC,DOBJ_MAINT_CD_ACTV_IND)
VALUES ('USPS','8999DCBC-B1D8-069E-F9B3-D296A6062E32',1.0,'U.S. Postal Service','Y')
/