Solved

How to edit the CLOB column data

Posted on 2009-04-08
8
4,980 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 74

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 74

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
LVL 74

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 74

Expert Comment

by:sdstuber
ID: 24140945
glad we could help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
format dd/mm/yyyy parameter 16 48
DECLARATION OF CURSOR IS INCOMPLETE OR MALFORMED 5 40
Oracle Errors 11 45
Oracle Query to Find number of process consumed by a session 15 52
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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 video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

713 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