Oracle获取用户下所有表名 获取表所有的列名及数据类型

select table_name from user_tables where TABLESPACE_NAME is not null and  user='UserName' 


SELECT table_name, column_name, data_type FROM all_tab_cols WHERE table_name = 'tablename ';