Blobs

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

Poston Thu, 29 Jul 2004 2:36 pm

Does anyone know a simple way to get a blob type from a table and insert into another?
A select on a table and then an insert in another?
Thanks for the help ...:-
lamanita
Location: Porto Alegre - RS

Samuel, o lamanit@

Poston Thu, 29 Jul 2004 3:01 pm

Can you do an INSERT. See example:
Code: Select all
insert into tabela2(cod, blob_foto) (select 1, blob_foto from tabela1);
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Fri, 30 Jul 2004 2:36 pm

Worse that works ... thanks!
: wink:
lamanita
Location: Porto Alegre - RS

Samuel, o lamanit@


  • See also
    Replies
    Views
    Last Post


      Return to SQL

      Who is online

      Users browsing this forum: No registered users and 2 guests