Home » Server Options » Text & interMedia » How do we find & replace a certain value in the database without even knowing th
How do we find & replace a certain value in the database without even knowing th [message #76117] Fri, 03 September 2004 01:50 Go to next message
S. M. Waqas Shabir
Messages: 30
Registered: January 2004
Member
Hi there!

How do we find & replace a certain value in the database without even knowing the table and/or field name?

Kindly suggest me an automated tool that can do it for me automatically!

The database is oracle 9i.

I need this suggestion immediately!

Best regards!
Re: How do we find & replace a certain value in the database without even knowin [message #76144 is a reply to message #76117] Sun, 28 November 2004 09:03 Go to previous message
Just Jonh
Messages: 4
Registered: November 2004
Junior Member
The simple approach is to write yourself a procedure (it will not be fast)!

cursor all the data-tables
cursor all the columns on the table
check the data-type for the column
perform search (and or update) for char

This is not nice but does its job. - and once you have the code you never have to loose data again :)

PS - plase post a copy once you have done it :)
Previous Topic: Saving big text files in Oracle
Next Topic: How to use & in contains keyword in context index
Goto Forum:
  


Current Time: Thu Mar 28 08:29:26 CDT 2024