1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Global seacrh some char value

Discussion in 'SQL PL/SQL' started by robix, Sep 1, 2014.

  1. robix

    robix Guest


    I have some Oracle Database. The base have some tables.
    I need to do query that perform search across all of the tables and if the table it is not empty then to search inside it across all of table's fields row by row and find CHAR value.
    And result of query is my table that have one field - table name where the CHAR value is matched.
    Can you please code this search.