how to search for keywords in the datebase

[mokesql]

hi!
i want to search for keywords in a db or in tables? how can i do it? are there any things i should know about? thnx

kemo

 

[Kenrae]

What do you mean by keywords? Searching a string on table data? Searching for, say, column names?? :?

 

[lfoata]

The only way I know is by writing an SQL query :
select col1,col2 from table1 where col3 like %keyword%. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA

 

[mokesql]

if i want to search for a word example, for keyboard in the whole table/db and i dont know in wich columns this word can be, i want to have alle results for a table. so i want to search in all columns without typint all columnnames like %word to search%. is there a possibility? thnx

 

[THoey]

???

SELECT *
FROM MyTable
WHERE UPPER(MyTable.Field1 || MyTable.Fieldn)
LIKE '%KEYBOARD%'; Terry M. Hoey