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 ';
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 ';
转载于:https://www.cnblogs.com/shengfly/p/8302317.html