Ed,

Perhaps you could use the DBMS_SQL Define_Column_Long and Column_Value_Long
procedures to manipulate the Long?

Converting the Long to a LOB using To_LOB function, then manipulating it
with the DBMS_LOB package might do, too.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



                                                                                       
                
                      "Ed Bittel"                                                      
                
                      <grep_oracle@hotm        To:       Multiple recipients of list 
ORACLE-L          
                      ail.com>                  <[EMAIL PROTECTED]>                 
                
                      Sent by:                 cc:                                     
                
                      [EMAIL PROTECTED]         Subject:  Size of a Long Field          
                
                                                                                       
                
                                                                                       
                
                      02/05/2003 08:53                                                 
                
                      AM                                                               
                
                      Please respond to                                                
                
                      ORACLE-L                                                         
                
                                                                                       
                
                                                                                       
                




How do you determine the size, in bytes, of a long field?

Please. No tape measure jokes.

Ed





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to