INSERT INTO TIPOITEMBLOCOK
  (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '00','N','S','S'
  FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '00')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '01','N','S','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '01')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '02','N','S','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '02')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '03','S','S','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '03')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '04','S','S','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '04')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '05','N','S','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '05')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '06','N','N','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '06')
/
INSERT INTO TIPOITEMBLOCOK
   (CDTPITEMPROD, IDITEMPRODUZIDO, IDITEMCONSUMIDO, IDITEMESTOQUE)
SELECT '10','N','S','S'FROM DUAL
 WHERE NOT EXISTS (SELECT * FROM TIPOITEMBLOCOK WHERE CDTPITEMPROD = '10')
/

COMMIT
/ 

