Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field
From: leo.larson <leo.larson_at_mci2000.com>
Date: Fri, 01 May 1998 02:05:51 GMT
Message-ID: <36a21.442$a5.363691_at_news.internetMCI.com>
Date: Fri, 01 May 1998 02:05:51 GMT
Message-ID: <36a21.442$a5.363691_at_news.internetMCI.com>
If you can get the long data into a pl/sql block, you can set a large varchar2 field equal to it. The max size of a varchar2 within pl/sql is above 32,000. If you need to you can write a function that can be called from a select statement if you restrict the references. James Preston wrote in message <35416470.FE07DD41_at_cs.rmit.edu.au>... Received on Fri May 01 1998 - 04:05:51 CEST