DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Search / Replace

  1. 02-21-2003, 04:46 AM #1
    tosahil
    tosahil is offline Junior Member
    Join Date
    Feb 2003
    Posts
    14

    Search / Replace

    We have a database in which we store HTML / XML code in tables.
    To implement small change in company’s name[ABC_CORP% to XYZ_CORP%], Web developers want to know
    1. All occurrence of ABC_CORP% - In which table, which column. In short first to pinpoint it.
    2. Later on they want to change all occurrence of ABC_CORP% to XYZ_CORP%

    Main problem is few columns are CLOBs containing HTML/XML code.

    Do anybody have something readily available
    OR at least guide me towards the best approach

    Thanks in advance.

    Sahil
  2. 02-21-2003, 09:46 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Closing, duplicate http://www.dbasupport.com/forums/sho...threadid=34079
    Jeff Hunter
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width