sql - Querying a Table which contains names of view -
i have primary table exporter has 3 columns col_1, col_2 , view_name.
i need able list of column_names , datatypes view_name(s) in exporter table.
i know how list of column names , data types view using :
select column_name, data_type all_tab_columns table_name = 'view';
but having difficulty figuring out how combine primary table , views.
Comments
Post a Comment