samedi 25 avril 2015

Find a string in a specific table


I'm working with a oracle database, I'm wondering if there is a way to find all rows that contains a value in any column. For example let's consider this table:

               Weather

city          state        high    low

Phoenix       Arizona      105     90

Tucson        Arizona      101     92

Flagstaff     Arizona      88      69

San Diego     California   77      60

Albuquerque   New Mexico   80      72

Basically (I know it's not possible), but I would like to do something like this:

Select * From Weather Where * LIKE '%f'

and it would give me the rows

Flagstaff     Arizona      88      69
San Diego     California   77      60

I could do it on the Java side, by querying all the rows then with the ResultSet dynamically search for a given value in a column and add that row. The problem is that some table contains millions of rows and I guess it would be more efficient do it on the database side, so I only fetch wanted rows from the network.

Is it possible to do it on the SQL side directly?


Aucun commentaire:

Enregistrer un commentaire