lomo1122的专栏

原创 导出oracle数据表及字段方法

select t.COLUMN_NAME as 字段,        t.DATA_TYPE as 字段类型,        t.DATA_PRECISION as 描述,        t.DATA_LENGTH as 长度,        t.NULLABLE as 是否为空   from USER_TAB_COLS t  where TABLE_NAME = 'STOCK_OUT