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
Introduction to LONGRAWBLOBCLOB type in Oracle
Introduction to the long raw blob clob type in Oracle
Note:
RAW: unprocessed type, which can store binary data or byte charactersLONG: variable-length string data. The maximum length is 2 GB. LONG
Datatypes translation between Oracle and SQL Server part 1:character, binary stringsDatatypes translation is one of the most important things you need to consider when migrate your application from one Database to the other. This is a article in the
ORACLE _ create and manage tables, oracle CreationZookeeper
ORACLE _ create and manage tables
① Common database objectsTable: A Basic Data Storage set consisting of rows and columns.View: logically related data set extracted from the table.Sequence:
The data type (datatype) is an attribute in the column or stored procedure.
Oracle supports three basic data types:
Character Data Type
Digital Data Type
Other data types
Character Data Type
CHAR: the char data type stores fixed-length
Reference 1. Introduction to Data Types in OracleConceptsOracleDataType: ## i41462.oraclejdbc#guid1] get and set of Object Data Types in java in workwithoracleobjecttype:
References 1. oracle Concepts introduction to Data Types in Oracle DataType:
1, set linesize 100; Set length2, set pagesize 30; Set the number of displays per page3. Em A.sql Open Notepad4, @ A executes the code in file A, you can specify the path of the file @d:a.txt5, conn user name/password to connect to the database
Oracle|sql language []oracle pl/sql Language Foundation
Oracle Pl/sql Language Basics
Pl/sql is Oracle's extension of the standard database language, Oracle has integrated PL/SQL into Oracle servers and other tools, and more developers and DBAs
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.