1 | initial version |
To retrieve the name of a column from a table in Oracle based on a certain value, you can use the following SQL query:
SELECT columnname FROM alltabcolumns WHERE tablename = 'yourtablename' AND owner = 'yourdatabaseowner' AND columnname like '%yourvalue%';
Replace 'yourtablename' with the name of the table you want to search and 'yourdatabaseowner' with the user who owns the table. Also, replace 'your_value' with the value you want to search for within the column.
This query will return the names of all columns in the specified table that contain the specified value.