Accessing user_tab_columns from different schema
Hello Experts,
We are using Oracle DB 11g.
I have a table 'myTable' which is in schema S1, I am firing below query from within schema S1 :
select char_length from user_tab_columns
where table_name = 'myTable'
and column_name = 'myColumn';
and getting value as = 64
My requirement is to call this from another S2, and get same value.
Any suggestion, pls.
Thanks in Advance.
From
KrishnaKumar and Sumit