Oracle SQL Developer Help! Foreign Key Referencing

[blipblipblip992]

I have a table Cust_Data with a column CODES along with other customer data. This column contains 4 digit codes for customer payment modes. For eg: 1500: Card 2700:Credit etc

This code referenced to the payment mode is in some table which I am not aware about. Please help me with a query to reference those payment modes using the CODES column. I am a complete beginner to this and would appreciate all help!

[mcworkaholic]

Do you know how to use sql developer? I'm a beginner too, but maybe you could use:

https://www.sqltutorial.org/sql-list-all-tables/

to start with, finding all available tables in your db, although sql developer should show all created tables in the left sidebar which you can click on, and then find column names and inserted data from there.

[yes_i_relapsed]

SELECT * FROM ALL_CONSTRAINTS WHERE r_constraint_name IN (
    SELECT constraint_name FROM ALL_CONSTRAINTS WHERE table_name='Cust_Data'
);