Database Administration (MOSC)

MOSC Banner

Accessing user_tab_columns from different schema

edited Feb 12, 2014 11:57PM in Database Administration (MOSC) 13 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center