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
Post a Comment