摘要: 1.打开visual basic 2.插入模块 3.粘贴宏代码 Sub CFGZB() Dim myRange As Variant Dim myArray Dim titleRange As Range Dim title As String Dim columnNum As Integer my 阅读全文
posted @ 2018-09-10 13:29 庖丁哥 阅读(2465) 评论(0) 推荐(0)
摘要: 1.导出全部表 1 SELECT COL.TABLE_NAME AS "表名", 2 TT.COMMENTS AS "表描述", 3 COL.COLUMN_NAME AS "字段名", 4 DECODE(COL.CHAR_LENGTH,0,DECODE(COL.DATA_SCALE,NULL,COL 阅读全文
posted @ 2018-09-10 10:45 庖丁哥 阅读(301) 评论(0) 推荐(0)