Inserting a text file into long column
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Tue, 5 Jul 94 08:55:00 -0500
Message-ID: <12a.3109.905_at_compudata.com>
Date: Tue, 5 Jul 94 08:55:00 -0500
Message-ID: <12a.3109.905_at_compudata.com>
-> Has anyone ever tried inserting the contents of a text file into a
-> long column of a table ? I heard that it is possible but how do I go
-> about doing it ?
Either use SQL-LOADER or write a PROC program to do it. If the values are less then 256 bytes in length you can actually use a SQL script with INSERT INTO TABLE TABLE_NAME VALUES('blah'), but if it runs over that you gotta get creative with PROC or SQL-LOADER. Received on Tue Jul 05 1994 - 15:55:00 CEST