RE: Bytes

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Mon, 2 Oct 2000 15:03:37 -0400
Message-Id: <10637.118336@fatcity.com>

Assuming we are talking Oracle 8i,

Max Columns# - 1000

Max Row Length: 2,000,000 Bytes

(The Oracle limit for the maximum row length is based on the maximum length of a row containing a LONG value of length 2 gigabytes and 999 VARCHAR2 values, each of length 4000 bytes: 2(254) + 231 + (999(4000)).)

FPIS Definition of Row Length - The FIPS PUB defines the length of a collection of columns to be the sum of: twice the number of columns, the length of each character column in bytes, decimal precision plus 1 of each exact numeric column, binary precision divided by 4 plus 1 of each approximate numeric column.

This information can also be found in the last chapter of Oracle SQL reference manual.

HTH
Raj

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

Received on Mon Oct 02 2000 - 14:03:37 CDT