ä¸ã SQLPLUSä¸ï¼ç´æ¥ç¨ DESC[ribe] tablename å³å¯ã
äºãå¨å¤é¨
åºç¨ç¨åºè°ç¨æ¥çORACLEä¸ç表ç»ææ¶ï¼åªè½ç¨ä¸é¢çè¯å¥ä»£æ¿ï¼
1ãçå段åä¸
æ°æ®ç±»å select * from cols
WHERE TABLE_name=upper('table_name');
--ï¼user_tab_columns缩åcolsï¼
2ãæ¥çå
¨é¨å
select * from user_tab_columns
where table_name = upper(âtablenameâ);
3ãæ¥çæäºå
select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE
from all_tab_columns
where table_name=upper('tablename');
4ãæ¥çæå®åçæ°æ®ç±»å
select DATA_TYPE
from User_Tab_Columns t
where t.column_name=upper('FIELDAåå')
and t.table_name =upper(trim('TEST2表å'));
5ãéè¿user_constraintsæ¥çææ约æ
select * from user_constraints where table_name = upper('tablename');
6ãæ¥ç主é®çº¦æï¼
select * from user_constraints where constraint_type='P' and TABLE_name=upper('table_name');