Tuesday, July 1, 2008

Advantages of LOB against LONG- Feature of LOB datatype

•LOB datatypes can be attributes of user defined datatypes.
•LOB locator is stored in the table column, either with or without the actual LOB value.
•Actually whenever LOB data is accessed the LOB locator is returned.
•LOB datatype supports transactional query, commit, rollback, update.
•In a table more than one column can have LOB datatype.
•Declare of LOB bind variable is possible.
•You can insert a LOB value with an existing LOB row datatype.
•You can update and delete a LOB row based on another LOB data type.

No comments:

Post a Comment