Feb 09 2005

Find A Value In All Table Columns

Jody posted this at 10:41 pm under computers, internet & computers, what i did today

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?


Email This Post Email This Post

11 Responses to “Find A Value In All Table Columns”. Leave a Reply.

  1. # Rebeccaon 10 Feb 2005 at 8:06 am

    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. # Penderon 10 Feb 2005 at 9:14 am

    I put up with your bullshit all day long! That’s why they pay me the mediocre bucks.. I think.

  3. # Rebeccaon 10 Feb 2005 at 2:25 pm

    Er… sorry about that…

  4. # Ryan Weagleon 11 Feb 2005 at 7:50 am

    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.

  5. # Jodyon 11 Feb 2005 at 8:53 am

    The patch won’t fix this particular bug; it’s in Oracle’s Mobile Server, which isn’t part of the database server.

  6. # Penderon 11 Feb 2005 at 10:07 am

    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.

  7. # Rebeccaon 12 Feb 2005 at 10:01 am

    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.)

  8. # Penderon 12 Feb 2005 at 12:45 pm

    Rebecca, are you hot?

  9. # Lindaon 12 Feb 2005 at 5:16 pm

    pender i have a feeling youre the big hottie round here - are you hot?

  10. # Rebeccaon 13 Feb 2005 at 9:09 pm

    Yeah, I’m frickin’ hot. There’s no thermostat in this frickin’ apartment, and it’s about 80C in here, even with the window open!

  11. # Penderon 15 Feb 2005 at 1:01 pm

    I’m a hotty von hotty hottenheimer.

Comments RSS

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Note: This post is over 3 years old. You may want to check later in this blog to see if there is new information relevant to your comment.

By submitting a comment here you grant this site a perpetual license to reproduce your words and name/web site in attribution.