It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Database update? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database update?" Watch "Database update?" New topic

Database update?

Edward Durai
Ranch Hand

Joined: Oct 09, 2004
Posts: 223
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"/>

Thank You<br />Edward
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Database update?
It's not a secret anymore!