Skip to Main Content
Forums

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!

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

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

Post Details

Locked on Mar 3 2010
Added on Feb 3 2010
#data, #general-database-discussions, #index, #on
1 comment
5,126 views