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 ';
flyliusheng
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 ';