Oracle CLOB (Character Large Object)

JDBC for Oracle - Herong's Tutorial Examples

∟Oracle CLOB (Character Large Object) - TEXT

This chapter provides tutorial notes on CLOB (Character Large Object) data types, TEXT, with Oracle JDBC Driver. Topics include creating tables to store CLOB values in Oracle server; inserting CLOB values with direct SQL INSERT statements, or PreparedStatement with setString(), setCharacterStream() or setClob() methods; retrieving CLOB values from ResultSet with getString(), getCharacterStream() or getClob() method.

These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.

Overview of CLOB (Character Large Object)

Create Tables with CLOB Columns

Inserting CLOB Values with SQL INSERT Statements

Inserting CLOB Values with setString() Method

Inserting CLOB Values with setCharacterStream() Method

Closing InputStream Too Early on setCharacterStream()

Retrieving CLOB Values with getString() Method

Retrieving CLOB Values with getCharacterStream() Method

Retrieving CLOB Values with getClob() Method

Inserting CLOB Values with setClob() Method

Takeaways:

Oracle Server support CLOB data type with column type of CLOB.
Character data can be directly inserted into a CLOB column using the INSERT statement.
Character data can also be indirectly inserted into a CLOB column using the PreparedStatement object with setSring(), setCharacterStream(), and setClob() methods.
Character data can be retrieved from a CLOB column using getString(), getCharacterStream(), and getClob() methods on the ResultSet object.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Oracle Express Edition Installation on Windows

Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

Oracle - PreparedStatement

Oracle - JBDC CallableStatement

►Oracle CLOB (Character Large Object) - TEXT

Oracle BLOB (Binary Large Object) - BLOB

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB