File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 3740

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!