This week's book giveaway is in the Design forum.
We're giving away four copies of Mastering Non-Functional Requirements and have Sameer Paradkar on-line!
See this thread for details.
Win a copy of Mastering Non-Functional Requirements this week in the Design forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Database update?  RSS feed

 
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: 4085
21
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!