Top "Clob" questions

How do I display the full content of LOB column in Oracle SQL*Plus?

When I try to display the contents of a LOB (large object) column in SQL*Plus, it is truncated. How …

oracle blob sqlplus clob lob

Is it possible to update data inside a CLOB using SQL?

I have a table having one clob column which has XML data in it. Say I want to replace XYZ …

sql oracle blob clob

extract a substring from clob in oracle

I have a clob with data <?xml version='1.0' encoding='UTF-8'?><root available-locales="en_US" …

oracle substring database clob

alternative to listagg in Oracle?

listagg is a function introduced in Oracle 11.2! now this function is bugging us allot, we are migrating from MySQL to …

sql oracle varchar clob

convert blob to clob

I'm using oracle 11g and I'm trying to find out the length of a text. I will normally use select …

oracle blob clob

Overcomplicated oracle jdbc BLOB handling

When I search the web for inserting BLOBs into Oracle database with jdbc thin driver, most of the webpages suggest …

java oracle jdbc blob clob

How to store unlimited characters in Oracle 11g?

We have a table in Oracle 11g with a varchar2 column. We use a proprietary programming language where this column …

oracle types blob oracle11g clob

How to export clob field datas in oracle sql developer

How to export clob field data's in oracle sql developer. Currently clob field data's can't export in oracle sql developer.

oracle export oracle-sqldeveloper clob

Insert CLOB into Oracle database

My question is: How do you get around the ORA-01704: string literal too long error when inserting (or doing anything …

java oracle jdbc insert clob

Displaying CLOB Column with 4000+ characters

I have this CLOB column and I need to display it using a select statement. I used DBMS_LOB.SUBSTR …

oracle clob