例如: 定义了一个视图, create or replace view outview_client_info as select PID,CODE,NAME,TYPE,SERVICESCOPE from bm_client_info 如何查询PID,CODE,NAME,TYPE,SERVICESCOPE的是什么类型的! 在线等!!!
------解决方案-------------------- select * from all_tab_cols where table_name = upper('bm_client_info') and column_name in ('PID','CODE','NAME','TYPE','SERVICESCOPE');
------解决方案-------------------- desc bm_client_info 或者desc view_name
------解决方案-------------------- desc view_name
------解决方案--------------------