select distinct t.COLUMN_NAME,t.DATA_TYPE || '(' || t.data_length || ')' from sys.all_tab_columns t where t.TABLE_NAME = '表名'
转载于:https://my.oschina.net/u/2446847/blog/1536242
转载于:https://my.oschina.net/u/2446847/blog/1536242