home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,929 of 2,288   
   Nathan Sokalski to All   
   Inserting a value for a BLOB field using   
   23 Nov 04 06:39:56   
   
   XPost: comp.database.oracle, comp.databases.oracle.misc, comp.da   
   abases.oracle.tools   
   XPost: relcom.comp.dbms.oracle   
   From: njsokalski@verizon.net   
      
   I am writing an SQL script for Oracle 9i. I have a table of which one field   
   is of type BLOB. I would like to create an SQL script to add records to this   
   table. What do I do to take a file and use it as the value for this field? I   
   know how to use the function EMPTY_BLOB() as the value, but I have been   
   unable to find a function that takes an actual image file and use it as the   
   data. Can someone give me an example or tell me a site where I can find one?   
   Any help would be appreciated. Thanks.   
   --   
   Nathan Sokalski   
   njsokalski@hotmail.com   
   www.nathansokalski.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca