Load Sql Text or Image to Oracle LOB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

alanw99REMOVE_at_yahoo.com
Date: 03/17/04


Date: Wed, 17 Mar 2004 10:09:44 -0800

Is it possible to use DTS to import from sql to Oracle?
Text to CLOB?
Image to BLOB?
If so, how?



Relevant Pages

  • Re: LONG to CLOB within a trigger - alternative to synching data values?
    ... originally designed before CLOB was a supported datatype!). ... we cannot do this owing the lack of support fro this in Oracle. ... CLOB or BLOB to a BLOB." ...
    (comp.databases.oracle.server)
  • Re: Oracle 10g Copy Blob
    ... Michel Cadot wrote: ... SQL> create table a (c blob); ... SQL> insert into a values; ... Version Oracle: 9.2.0.6.0 ...
    (comp.databases.oracle.server)
  • How to create CLOB within ANYDATA ?
    ... and find documentation very sparse. ... INSERT INTO ATABLE VALUES ) but an attempt with CLOB ... I would be working with 'internal' CLOBs, and according to the Oracle ... is it possible to do this plus the insert within a single SQL ...
    (comp.databases.oracle.misc)
  • Oracle 10g : is possible return a sys ref cursor for sql from clob variable
    ... is possible a function return a sys ref cursor for sql from clob ... variable i ORACLE 10g, something like this: ... FUNCTION TEST AS ... L_QS CLOB; ...
    (comp.databases.oracle.server)
  • Re: strip HTML tags from fields?
    ... I'm trying to take some HTML fields and strip out the HTML ... The Policy_Filter seems to want to use a Blob, ... output_c clob; ... I'm new to Oracle, so go easy on me please:) ...
    (comp.databases.oracle.misc)