Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to edit the CLOB column data

Posted on 2009-04-08
8
Medium Priority
?
6,148 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 600 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 1400 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

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ā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

704 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