1. How to Deal with clob in MySQL and Oracle databases. BLOB data type (1) cannot be connected to clob in the database. The Blob type is as follows:
MySQL: clob corresponds to text and blob
In DB2/Oracle: clob corresponds to clob and blob(2)
In Oracle, fields of the lob (large object, large object) type are increasingly used. This type of field has a large capacity (up to 4 GB of data), and a table can have multiple fields of this type, which is flexible, applicable to business areas
Modern database systems in addition to supporting a number of standard common data types, most also support a kind of data called blob type.BLOBs are all called big large object bytes, a sophomore, and this type of data is typically used to store
The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.
Writing BLOB fields is very different from writing other types of fields. Because blob itself has a
The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.
Writing BLOB fields is very different from writing other types of fields. Because blob itself has a
The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.Writing BLOB fields is very different from writing other types of fields. Because blob
The Blob field in Oracle is special. It has much better performance than the long field and can be used to save binary data such as sample slices.
Writing BLOB fields is very different from writing other types of fields. Because blob itself has a
oracle| Data Oracle's BLOB field is special, he is much better than a long field, and can be used to save binary data, such as pictures.
It is very different to write a BLOB field and write to another type of field, because the BLOB itself has a
How to Insert BlobData(image, video) intoOracleBlob Sizein This post it's shown how I can insert Blob data link image video to Oracle database and also how I can dete Rmine the size of the BLOB data from Oracle.1) Create Directory Where BLOB resides.
Insert and display images in Oracle (BLOB type)Blob type for storing images in oracle
First, create a database:
-- Connect to the AdministratorConn sys/tbsoft as sysdba;
-- Authorize scott user
Grant create any directory to scott;
-- Return to scott
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.