Solved

How to edit the CLOB column data

Posted on 2009-04-08
8
4,429 Views
Last Modified: 2013-12-18
Hi,
I have a table say Table  Table_A which has a clob data column column_A. Within that column I have a record whose value is 'abc'. I want to change that value to 'cde'. I am connected to oracle 10g using Toad and SqlDeveloper. I could not find option to edit the clob column data. Please suggest me how can i edit clob column data. Any links, resources, ideas highly appreciated. Thanks in advance.
0
Comment
Question by:gudii9
  • 4
  • 3
8 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 24104084
you can update a clob much like you would any other type

update your_table set your_clob = 'cde'


if this doesn't work you must have a more complicated scenario than described above.
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 150 total points
ID: 24109360
If you use SQL Developer, updating a single field is pretty easy. Open the table, click on the Data tab, then double-click on the column you want to modify (you may have to filter out the data as needed). Make your changes, then click OK and then commit.
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 350 total points
ID: 24109444
In Toad you can open your table in the schema browser,  double click on the CLOB cell in the data tab and it will bring up a window to edit the clob contents

you can also use the Toad keyword "edit"  on the sql editor
use it like you would a select statement


edit your_table where ....

the result grid produced by that query will be editable,  double clikc on the clob cell in the grid and it will bring up a window to edit the clob contents
0
 
LVL 7

Author Comment

by:gudii9
ID: 24111790
In Toad when I open my table in the schema browser,  double click on the CLOB cell in the data tab and it is bringing up a window to but not allowing to edit. Please advise. Same thing happening with SQLDEVELOPER also.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 73

Expert Comment

by:sdstuber
ID: 24112487
perhaps you don't have update privileges on the table
0
 
LVL 7

Author Comment

by:gudii9
ID: 24130307
when i ran the update query it worked. But when i try to edit by bringing up window it does not. Not sure why.
0
 
LVL 7

Author Closing Comment

by:gudii9
ID: 31568380
thank you
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 24140945
glad we could help
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now