Database Administration (MOSC)

MOSC Banner

what view/table will show me what view columsn belong to which table columns?

edited Sep 21, 2010 7:16PM in Database Administration (MOSC) 7 commentsAnswered
I have a very complexed view that retrieves information from several tables, and I need to know what table columns these view columns are referencing, for example:
create sds_test (sds_num number, sds_data varchar2(50);
create sds_view (test_num,test_data) as (select sds_num,sds_data from sds_test);

How can I find out what table column test_num on the view sds_view is referencing, i.e. result would be sds_num on the table sds_test.

Thanks. Regards, Sheryl

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