blob can only work using procedure?

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 06 Mar 2008 4:15 pm

Hello everybody, I would like to confirm that, for working with images in Blob fields in oracle, so much to give a insert, update, and a select I need necessarily use a procedure?

There is no product oracle propria for blob fields?

that way if I have a table:
Code: Select all
CODIGO NUMBER
NOME    VARCHAR2
DESCRICAO VARCHAR2
FOTO BLOB
first I do an insert in other fields and after I run the procedure to include the image into blob field?

When you give a selexct will be the same thing, give a select in other fields to then run a procedure that retrieves this field?

a strong abarco all alineri
alineri
Location: RJ

Poston Thu, 06 Mar 2008 4:46 pm

Aline, OK?

Take a look here on the Forum, for DBMS_LOB, which is a package for manipulating LOBs.

qualquer thing, send it to us, okay?
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP



Return to SQL

Who is online

Users browsing this forum: No registered users and 3 guests