RE: Record Length ...

From: tapas dutta <tapasoracle_at_umtl.co.in>
Date: Wed, 14 Mar 2001 21:29:39 -0800
Message-ID: <F001.002CD3E7.20010314205019@fatcity.com>

Use the command vsize. The format is vsize(coulmn_name) But you have to write some pl/sql code for the purpose.

Regards,
Tapas

-----Original Message-----
From: Harsh Agrawal [SMTP:HARSHA_at_Amdocs.com] Sent: Monday, March 12, 2001 7:01 PM

To:     Multiple recipients of list ORACLE-L
Subject:        Record Length ...

Hi,

I have a table containing CHAR, VARCHAR2, NUMBER and DATE fields.

Is there any way or command to find out the record length in bytes.

This can be useful while defining a Buffer in Pro*C to handle a record.

Thanks in Advance.

Harsh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harsh Agrawal INET: HARSHA_at_Amdocs.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: tapas dutta
INET: tapasoracle_at_umtl.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------