oracle - Need Column name where I know the database and table names -


i know database , table name , need find column name. example in emp table; know data 7369 , table name emp, , need column name empno. table has hundreds of columns , getting difficult search each column name.

you don't have choice search in every column. please note though value could, potentially, appear in multiple columns and/or multiple times in single column. there's no way restrict how appears across entire table.

this point of database; stored in column and, importantly, column has meaning. if disassociate data stored in column meaning have search everything.


Comments

Popular posts from this blog

node.js - Bad Request - node js ajax post -

Why does Ruby on Rails generate add a blank line to the end of a file? -

keyboard - Smiles and long press feature in Android -