Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE VEHICULO
- ADD FOTO BLOB DEFAULT EMPTY_BLOB() -- NO EXISTE EL NULL PARA ESTE TIPO DE DATOS (BLOB)
- LOB(FOTO) STORE AS (TABLESPACE OBJETOS_LOB);-- BLOB: OBJETO BINARIO DE GRAN TAMAÑO
- DECLARE
- V_ERRORM VARCHAR2(200);
- V_BLOB BLOB;
- V_BFILE BFILE:
- CURSOR C1 IS
- SELECT PATENTE, FOTO
- FROM VEHICULO;
- V_REG C1%ROWTIPE;
- BEGIN
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement