Is it possible to edit a row in a table?

[meetramana]

Hi,

Is it possible to edit a row in a table?

Actually the data in the row is in xml format. However,I exactly know from which point to which to point to be deleted.

for example:

The information in the row is like this

<HEAD.............><...../><...../></HEAD><HEAD2.............><...../><...../></HEAD2><HEAD3.............><...../><...../></HEAD3><HEAD4.............><...../><...../></HEAD4><HEAD5.............><...../><...../></HEAD5><HEAD6.............><...../><...../></HEAD6>

I want to delete the data <HEAD2.............><...../><...../></HEAD2>

Please let me know if there is any to do this with out deleting the row

Thankyou

 

[jrohrbach]

Is this one column of one rwo or multiple columns? Any column can be edited, that is, updated, so long as it is not one of the index keys. The short answer is that you would fetch the row, manipulate the data as deisred, then update the row with the new value for that column.

If what you are asking, however, is to be able to have an SQL statement that will delete all the "<HEAD2.............><...../><...../></HEAD2>" regardless of the text between the tags, that is a different matter entirely and I am not sure that it can be done.

Ever onward,
jar

 

[meetramana]

Hi jar,

Thankyou for your reply,
Yes that is one column of one row
And we don't need to delete regardless of the text between the tags.

I exactly know the full text between the tags that needs to be deleted.

For example : ( Some funny Text: just an example)

<HEAD2 233Pseudophiles are attempting to win the lottery by using naked mento spread the Ebola virus><They have stopped playing Magic:The Gatheringin order to cause mild confusion/><The only way to stop them is to send some text files to the creator of this junk and stop as this will increase UV radiation./><Obviously, this will put you at risk of being mistaken for David Hassleh off but you can be sure that your actions will make you feel a lot better about yourself/></HEAD2>

I don't know what to do? or if that is possible to delete?

any ideas?

Thankyou once again

 

[Mercury2]

meetramana,
How is the column declared in the file ? Is it a CLOB field (Character Large Object) ?

 

[meetramana]

Hi Mercury,

yes it is a CLOB field

Thankyou for the response

 

[Mercury2]

Well, look here and follow the thread. I show how to retrieve a section of text from a clob column in a file.
From there, the program is nearly written. You'll scan the text in the column and take out the excerpt from the text playing with SUBSTR and POSSTR SQL functions to eventually update the row in your file.