0

I have a column in a table which has codes for a specific value. For ex, the column 'CODES' in table 'LOG_DATA' contain data which are codes for other values and referenced in some other table which I don't know about. How do I look up the 'CODES' column to get the respective values for each data in my column?

I have tried DECODE but I am not able to structure the statement properly

Ken White
  • 123,280
  • 14
  • 225
  • 444
db72
  • 1
  • 1
  • Please refer https://stackoverflow.com/questions/1143728/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer or https://stackoverflow.com/questions/1729996/list-of-foreign-keys-and-the-tables-they-reference-in-oracle-db – Sai Kumar Oct 28 '22 at 02:22

0 Answers0