• Post Reply Bookmark Topic Watch Topic
  • New Topic

Database update?

 
Edward Durai
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have one table named as customtable
and it contains one field name is customfield

one data is like

<ISSUES Data_26=""/>

i want to update this query.

My expected output like
<ISSUES Data_26="custom filed"/>
 
Scott Selikoff
author
Bartender
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As far as I can recall, there's no standard for wildcard replacements in the database world. You could probably whip something up with PL-SQL/T-SQL although it might not be easy. Your best bet is to read the data on the application server, modify it manually yourself just as a String, and then save it back to the database.
 
Hang a left on main. Then read this tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!