Query generated by Oracle contains all data table record statements corresponding to the specified field name

Application Scenario: if the field name is known, query all data tables in the database that contain the field name.

Operation Method: Specify the field name, database table user, and execute the following query statement.

-- Oracle generates query statements that contain records of all data tables corresponding to the specified field name

Declare
Mycolumnname VARCHAR (255): = 'userid'; -- defines the field name variable to be queried and changes it to the field name to be queried before running
End;

The running result is similar to the following statement: