Inserting CLOB Values with SQL INSERT Statements. Inserting CLOB Values with SQL INSERT Statements This section describes how to insert CLOB values as string literals using SQL INSERT statements. The simplest way to insert a character string into a CLOB column is to use a SQL INSERT statement and include the character string a SQL string literal in the statement as shown in this sample program: Compilation and execution of this program is below. The output confirms that the character string value was correctly inserted into the CLOB column: C:\>javac -cp .
;\local\lib\ojdbc14.jar OracleClobInsert.java C:\>java -cp . ;\local\lib\ojdbc14.jar OracleClobInsert The inserted record: Subject = Test on INSERT statement Body = A BLOB (Binary Large OBject) is a large chunk of data which is stored in a database. Using SQL string literals to insert CLOB values into database is not recommended, because quote characters (') in the CLOB values must be replaced with escape sequences ('').
Using PreparedStatement with setXXX() method is a much safer choice. Oracle Tip: Create functions to join and split strings in SQL. Oracle Tip: Create functions to join and split strings in SQL. Blog Archive » How to SELECT from a comma delimited list. Update clob data : CLOB « Large Objects « Oracle PL/SQL Tutorial. Forum: SQL & PL/SQL » oracle sql UPDATE CLOB. Split function. Search all Database to find a word. Coloring column in sql report.