Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Unanswered: Looking for values in oracle 10g


    I'm trying to find out if any columns/rows in the whole schema that contain a certain name 'AABBCC'. Could you please advise if there is such a query that can be written?


    A query that can be run on schema level searching all tables for this entry?


  2. #2
    Join Date
    Nov 2003
    Provided Answers: 8
    Unless you want to write a PL/SQL procedure, there is no "native" command to do this.

    There are however some SQL tools which can do something like this, e.g. SQL Workbench/J's "WbGrepData" command: 17.*Other SQL Workbench/J specific commands

    I wouldn't be surprised if SQL Developer (the tool from Oracle) can do this as well (but I don't use it, so I'm not sure)
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags:

    Tips for good questions:

Posting Permissions

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