INDEX on RAW data type
728256Feb 3 2010 — edited Feb 3 2010Hi,
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