Oracle8i Application Developer's Guide - Large Objects (LOBs) Release 2 (8.1.6) A76940-01 |
|
Frequently Asked Questions, 2 of 11
Can I insert or update any length of data for a LOB column? Am I still restricted to 4K. How about LOB attributes
When inserting or updating a LOB column you are now not restricted to 4K.
For LOB attributes, you must use the following two steps:
Example: Copy Long to LOB Using SQL :
INSERT INTO Multimedia_tab (clip_id,sound) SELECT id, TO_LOB(SoundEffects)
Does this work if the data in LONG or LONGRAW is > 64K?
Yes. All data in the LONG is copied to the LOB regardless of size.
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|