Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: beginner: LONG, BLOB, CLOB

Re: beginner: LONG, BLOB, CLOB

From: Dan <dmorgan_at_exesolutions.com>
Date: Wed, 11 Nov 1998 10:25:51 -0800
Message-ID: <3649D6AF.FB7C5D5C@exesolutions.com> 





> But how do I get the data in? SQL*Plus does not accept more than 2399


> chars by line but due to the "memos" my INSERT statments are quite longer.


>


> Is the only way to bind the ROW using the API?





You can import the data using Access, though I would use SQL*Loader. What you
should never do is build objects using Access. Just build the tables first and
then perform the import.



Daniel A. Morgan

Received on Wed Nov 11 1998 - 12:25:51 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US