SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BLOB Datatype Length.

2616901Feb 20 2014 — edited Feb 20 2014

Hi Everyone. I have a question on Oracle Blob datatype.

I need to store Image data in my table there are 4 fields which store 4 different images for a record in a table.

The image size would not be more than max 500KB,

Is it advisable to specify the column data type as Just BLOB ( which defaults to size of 2GB)

Or specify the datalength?

Length is specified in number of octets, is this the same as Bytes? so can i go for BLOB(500K)?

Regards,

Glen.

This post has been answered by JustinCave on Feb 20 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2014

Added on Feb 20 2014

#blob, #data

2 comments

1,207 views