如题所述
æ¹æ³ä¸ï¼å¯ä»¥ç¨user_tab_cols表è¿è¡æ¥è¯¢ï¼æ¥è¯¢æç»æ表示å段åå¨ï¼
sqlï¼select * from user_tab_cols where table_name='T_AAA' and column_name='COL_BBB';
æ¹æ³äºï¼ä¹å¯ä»¥ç¨all_tab_columns表è¿è¡æ¥è¯¢ï¼æ¥è¯¢æç»æ表示å段åå¨ï¼
sqlï¼select * from all_tab_columns where owner='SYS_CCC' and table_name='T_AAA' and column_name='COL_BBB';
sqlï¼select * from user_tab_cols where table_name='T_AAA' and column_name='COL_BBB';
æ¹æ³äºï¼ä¹å¯ä»¥ç¨all_tab_columns表è¿è¡æ¥è¯¢ï¼æ¥è¯¢æç»æ表示å段åå¨ï¼
sqlï¼select * from all_tab_columns where owner='SYS_CCC' and table_name='T_AAA' and column_name='COL_BBB';
温馨提示:答案为网友推荐,仅供参考