Oracle 7.3, parsing the contents of a LONG column?
From: Guy Starbuck <guy.starbuck_at_syllogistics.com>
Date: Wed, 22 Apr 1998 14:45:18 GMT
Message-ID: <353E0295.424D38F7_at_syllogistics.com>
[Quoted] I want to use a PL/SQL procedure to process the contents of a single LONG column. This column will be filled with the contents of a fixed format but variable length flat file.
Date: Wed, 22 Apr 1998 14:45:18 GMT
Message-ID: <353E0295.424D38F7_at_syllogistics.com>
[Quoted] I want to use a PL/SQL procedure to process the contents of a single LONG column. This column will be filled with the contents of a fixed format but variable length flat file.
Since you cannot use "substr" or other string parsing functions on a LONG column, does anyone know of any SQL or PL/SQL functions which can be used to extract sections of a LONG column?
Any help would be appreciated.
Guy Starbuck
guy.starbuck_at_syllogistics.com
Received on Wed Apr 22 1998 - 16:45:18 CEST