Search all columns of the database oracle SQL

Question

Question

OviliaExplorer

Asked: July 6, 20222022-07-06T07:29:00+03:00 2022-07-06T07:29:00+03:00In: Oracle SQL

I have a column name called transaction_quantity and want to know the tables that have this column name and the owner of the table.

You must login to add an answer.

Need An Account,

Hassan AbdElrahman · Accepted Answer · 2022-07-07T00:14:54+03:00

To find The tables which contain a particular column name, you can use the following query:

SELECT owner, table_name, column_name 
FROM all_tab_columns 
WHERE column_name LIKE '%TRANSACTION_QUANTITY%';

The output of this select statement would be:

You can get the result from a specific owner schema like ‘INV’ and so on.

You may also be interested in checking my answer to other related questions from here Get Column Name from Table in Oracle