Menu
Could anybody tell why oracle allows only one "LONG" datatype column per table.
292
The absolute maximum number of columns in a table is 1000.
Only one Long column can be present in a table.
The LONG RAW datatype represents fixed-length, binary data or byte strings. The maximum length of a LONG RAW value is 2147483647 bytes (two gigabytes).
LONGs were stored inline with the table data, so Oracle probably limited it to one per table because of that (performance hit as you'd be scanning over a lot of blocks) whereas LOBs are stored inline for only the first few k then go into the LOB segment for the rest.
As LONGs are totally depreciated and a major pain in the butt to deal with, stay well away from them where possible.
112
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
