Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

INDEX on RAW data type

728256Feb 3 2010 — edited Feb 3 2010
Hi,

I read this from a web site. Please let me know fi thsi is correct.

The raw datatype is used to store binary data or binary strings. The maximum size for a raw in a table is 2000 bytes. Within a PL/SQL piece of code, the maximum size is 32767 bytes. The raw datatype is similar to the varchar2. However, Oracle does not interprete the data stored within a raw when applying character set conversion.

If the above is correct them, What happens when I create Index on this column. We have table with Primary key on Raw column. Is this acceptable or a wrong way of creating the table.

Please explain in detail if possible or direct me to a book or URL where I can find the information.

Thanking you
Rocky

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 3 2010
Added on Feb 3 2010
1 comment
5,088 views