Talk:Comparison of relational database management systems: Difference between revisions

Revision as of 19:28, 12 December 2024

Latest revision as of 14:11, 14 January 2025

Line 145:

----

The assertion that the maximum row size in Oracle is 8KB is also incorrect. While it does not appear in a document, at least as of version 10.2 of Oracle, the row size can easily exceed 8KB. For example, this is perfectly valid:

<syntaxhighlight lang="sql">

<code>

CREATE TABLE BLEAH (

A1 CHAR(2000 BYTE),

Line 154:

A6 CHAR(2000 BYTE),

A7 CHAR(2000 BYTE));

</syntaxhighlight>

</code>

This example can be extended to the full 1000 column limit to create a table with a physical row length of 2000000 bytes. So, while the row length limit is not apparently documented, it is definitely not 8K.