Only know know the primary key ID string type, it is necessary to find out the in which which column in the table are cited.

CodePudding user response:

Select * from all_tab_cols;
If what you said is foreign key relationships and associated to this list
Select * from user_constraints where constraint_type='R';

CodePudding user response:

Seems no good method, if the data is less, there is a simple and crude way,
All the data export text format, then use the text search tool,

CodePudding user response:

reference 1st floor nayi_224 response:

select * from all_tab_cols;
If what you said is foreign key relationships and associated to this list
Select * from user_constraints where constraint_type='R';

1 l positive solutions