如何用SQL语句获取Oracle指定表的表结构

1、SELECT *
FROM ALL_TAB_COLUMNS where owner='USE1' and table_name ='B'; 

2、desc 表名 
3、SELECT column_name AS FIELDNAME,data_type AS TYPE,data_length AS SIZE,nullable AS ISNULL FROM user_tab_columns where table_name = 'tablename'