Find A Value In All Table Columns

I wrote a korn shell script that has embedded PL/SQL, which searches all table columns for a specified value in a specified schema. Why, you ask, did I do that? Because an Oracle product that we’re using has a bug that causes it to become corrupt if any data contains TAB characters, and I didn’t want to manually search all our tables for TABs.

What did you do?

11 Replies to “Find A Value In All Table Columns”

  1. I explained to someone what MARC formatting was and why libraries who have automated systems automatically have all their records formatted in this manner. I finished testing a new build of a union catalogue for the interlibrary loan system which we belong to. And some other stuff that I forget.

    (Edited by website administrator to include link explaining what the hell MARC formatting is.)

  2. I wrote an implementation plan to upgrade Oracle to the latest patch set so that your database won’t have to deal with that bug. Sorry to have wasted your time.

  3. Rebecca, I was talking to jody (in case you were put off thinking I was talking to you). I work with him. He’s my pseudo-boss entity. Hence my putting up with his bullshit all day!

    I actually ran out and looked up the MARC format.. It wasn’t as entertaining as I thought it would be.

  4. Pender – don’t worry, I had’t thought you were talking to me :) Yeah, MARC is only really interesting to a certain sub-sect of librarians – the geeky ones. (Yes, it is possible to be even geekier than simply being a librarian.)

Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.