Introduction to the long raw blob clob type in Oracle, blobclob
Note:
RAW: unprocessed type, which can store binary data or byte charactersLONG: variable-length string data. The maximum length is 2 GB. LONG has the VARCHAR2 column feature. It can
DescriptionRaw: Unprocessed type, can store binary data or byte charactersLong: variable long string data, longest 2g,long has VARCHAR2 column attributes, can store long text in one table up to a long column "not recommended"Long RAW: variable Long
The data type used to hold the bit string in Oracle is Raw,long RAW (the recommended use of BLOBs).
Raw, similar to char, declared as Raw (L), L is length, in bytes, as the largest database column 2000, as a variable of the largest 32767 bytes.
Long
Recently, when studying the V$latch view, I found a data type that I had never seen before. The data type of the Addr property in V$latch is Raw (4|8) and the data type of the addr attribute in v$process is also raw (4|8). So we looked at Oracle's
The raw type is a data type that is used in Oracle to hold a bit string, similar to char, declared with a raw (L) method, up to 32767 bytes long. The system provides a SYS.UTL_RAW toolkit for raw type operations, and the commonly used functions are
A bare device, also called a raw partition, is a special character device that is not formatted and read by unix through a file system. It is read and written by the application. Buffer through the file system. Because the bare device does not pass
Raw (size): The original binary data of size byte, the maximum value of size is 2000 bytes;Raw type benefits: When raw data is transferred between computers in the network, or when raw data is moved from one database to another using the Oracle
RAW, similar to CHAR, is declared as RAW (L). L is the length, in bytes, and serves as the maximum 2000 bytes of the database column and the maximum 32767 bytes of the variable. LONGRAW, similar to LO
RAW, similar to CHAR, is declared as RAW (L). L
The following articles mainly explain the Oracle Raw type in detail. We first talk about the concept of RAW, which is similar to CHAR in that aspect, the declared method is RAW (L). It takes L as the length, and the relevant bytes as the unit. It
Sometimes, because of project development, some tables in the SQLServer2005 must be synchronized to the Oracle database, which can be read by other systems. Data synchronization between different database types can be implemented using linked
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.