Multiple Schemas Query
593139Dec 11 2007 — edited Dec 14 2007Hi,
Can someone please tell me if there is a way to query the several tables on multiple schemas, for instance TABLE1 which is present in every schema. I was trying to do it in a FOR LOOP using CURSORS but had very little sucess. One cursor held the USERNAME(Schema) from the ALL_USERS table
I basically want a way of appending the username inside a FOR LOOP to query each table in each schema. If some one could shed some light on this it would be great!