select DATA_TYPE from ALL_TAB_COLUMNS where TABLE_NAME='aaa' and COLUMN_NAME='col_a';
select data_type from dba_tab_columns where table_name='TABLE';
只要有select的权限就可以了
大写哦 select DATA_TYPE from ALL_TAB_COLUMNS where TABLE_NAME='AAA' and COLUMN_NAME='COL_A';
发现如果当前用户是DBA级别的,如果where语句中只有TABLE_NAME='AAA' and COLUMN_NAME='COL_A',查找出来的会有多条记录,因为现在有多个Owner。所以希望多加个Owner的限制条件,如下:select * from ALL_TAB_COLUMNS where TABLE_NAME='PP_USER_PROFILE' and COLUMN_NAME = 'PROF_DATE_START' and OWNER = 当前用户; 但怎么获得当前用户呢?
但怎么获得当前用户呢?