例如:
定义了一个视图,
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
------解决方案--------------------