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.

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

This message: [ Message body ]
Next message: Guy Starbuck: "Re: Designer 2000 - Webserver - PL/SQL"
Previous message: Damon Bowman: "Oracle 7 - NT ODBC connect problem - "access violation""
Next in thread: Lane_Associates_at_Compuserve.com: "Re: Oracle 7.3, parsing the contents of a LONG column?"
Reply: Lane_Associates_at_Compuserve.com: "Re: Oracle 7.3, parsing the contents of a LONG column?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message