method One:
In Oracle, fields for LOB (Large object, large objects) types are now used more and more. Because of this type of field, large capacity (up to 4GB of data), and a table can have more than one of these types of fields, is flexible,
-clob (Character Large Object)-For storing large amounts of text data-There are some special characters, different database processing methods, the operation of large large segments is often handled in a streaming manner. Rather than a normal field,
BackgroundOracle field type VARCHAR2 Maximum length 4000, what to doSolveUse CLOB type, large print segment, no length limitProblemThe CLOB type obtained by using the Java JDBC Read RS is not working properly, encapsulating the Rs.getobject (). If
Pl/sql Procedure: Data reading of Clob field types in Oracle 11g
the database column of the LOB type stores only the locator, which points to the storage location of the large object.
manipulate LOB data with the Dbms_lob package. When reading
OverviewThis paper describes the implementation of large-text reading and writing of database through Spring JdbcTemplate, based on a blog of a netizen, review the API documentation.Write implementation1JdbcTemplate JdbcTemplate =NewJdbcTemplate
DB2 has three types of large print segments:CLOB (Character Large OBjects)For storing single-byte strings, we should consider using CLOB when we want to save more characters than the maximum length of varchar (32K).Dbclob (double-byte Character
1. Background Large numbers of data migrations have always been a headache, and it is not possible to use SQL statements to implement inserts and updates when the value in large segments is greater than 32K. There are generally two common solutions:
1. Sysdba the user to assign permissions# Sysprivilege.sqlPrompt----Connect to sysdbaset serveroutput on;prompt----Create user aq and Aq_userdrop user aq Cascade;drop user Aq_u Ser cascade;create user aq identified by Aq;create user Aq_user
Detailed description of ing elements in the hibernate configuration file
Detailed description of ing elements in the configuration file Object link ing is described in an XML document. Ing documents can be generated using tools, such as
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.