var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: same field with differenet tables
im using EmpName filed in lot of tables in oracle data base.
how to write a query to find how many tables contains EmpName
thanks in advance
Query USER_TAB_COLUMNS (or even ALL_TAB_COLUMNS):
I hope you didn't really name it 'EmpName' (note combination of capital and small letters); if you did, you'd have to enclose column name into double quotes.
WHERE column_name = 'EMPNAME';
thanks a lot
it is working fine