Value of columns inOracle tables

by user146611   Last Updated March 13, 2018 08:06 AM

I have many schemas in one oracle databse named SCHEMA1, SCHEMA2...SCHEMA999

I want to find specific value of column named "JN_OSUSER" which is string 'Ed.Spencer'

How to find in every table, in my wholedatabase, column value which contain string value 'Ed.Spencer'?

Tags : oracle string

Related Questions

inserting string value with hyphen and comma

Updated March 04, 2017 10:06 AM

Performance to find the string with like operator?

Updated November 28, 2017 09:06 AM