I am looking for a SQL Query which will give me a list of tables from a schema.
All the tables in the schema have a column called "created_by". And, each of these tables are populated using ETL processes by different users, say for example USER1, USER2, USER3 and so on. When the ETL process updates by logging as a user, the field "created by" is updated by the user name... USER1 or USER2 or USER3 etc.
I would like to know which tables are populated by USER2 in a schema.
I am using Oracle 10g on Windows 2003. Please need you help.
Hi irfan, if i am right, you want to list all the tables whose a particular column has a particular value. I had a similar requirement sometime back and I used this little piece of code at sql prompt, which I found after searching on the net.
This code when executed at SQL*Plus prompt, builds and runs SQL to find all user tables with a particular column and value, spools the results to a file, and opens the file in Notepad.