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
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
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
Today we will mainly introduce you to the interpretation of common Oracle Raw types. We all know RAW, which is very similar to CHAR. We declare it in Oracle RAW (L ), L is the length, in the unit of correlation bytes. It is used as the maximum 2000
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
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
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
JDBC reads the Oracle long RAW field with text in itReference:http://singlewolf.iteye.com/blog/278769http://blog.csdn.net/restraint/article/details/7190265http://blog.csdn.net/bq1073100909/article/details/49335491String sql = "Select condition from
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.