Update Clob Data Using Sql Query After Connecting To Database Using Dbsql (Doc ID 1919593.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database Mobile Server - Version 11.3.0.0.0 and later
Information in this document applies to any platform.

Goal

Need to  update the clob data directly using update query after connecting using dbsql.

1. Connect to database using dbsql
2. Trying to update one clob column using below update query:
update T_CLOB set COL_CLOB = "Marc will continues to excel and perform at high levels exceeding many of his goals. He developed the FY15 Core Proposal, oversees the Support Division's three ....';
 It becomes a Junk rows

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms