oracle相关01

scheme区分大小写

1094 [main] DEBUG com.baomidou.mybatisplus.generator.config.querys.OracleQuery  - 执行SQL:SELECT * FROM ALL_TAB_COMMENTS WHERE OWNER='sht'
1155 [main] DEBUG com.baomidou.mybatisplus.generator.config.querys.OracleQuery  - 返回记录数:0,耗时(ms):62
1161 [main] WARN  com.baomidou.mybatisplus.generator.IDatabaseQuery$DefaultDatabaseQuery  - 表[GOODS]在数据库中不存在！！！

修改大小写

1026 [main] DEBUG com.baomidou.mybatisplus.generator.config.querys.OracleQuery  - 执行SQL:SELECT * FROM ALL_TAB_COMMENTS WHERE OWNER='SHT'
1140 [main] DEBUG com.baomidou.mybatisplus.generator.config.querys.OracleQuery  - 返回记录数:17,耗时(ms):114
1165 [main] DEBUG com.baomidou.mybatisplus.generator.config.querys.OracleQuery  - 执行SQL:SELECT A.COLUMN_NAME, CASE WHEN A.DATA_TYPE='NUMBER' THEN (CASE WHEN A.DATA_PRECISION IS NULL THEN A.DATA_TYPE WHEN NVL(A.DATA_SCALE, 0) > 0 THEN A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')' ELSE A.DATA_TYPE||'('||A.DATA_PRECISION||')' END) ELSE A.DATA_TYPE END DATA_TYPE, B.COMMENTS,DECODE(C.POSITION, '1', 'PRI') KEY FROM ALL_TAB_COLUMNS A  INNER JOIN ALL_COL_COMMENTS B ON A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME AND B.OWNER = 'SHT' LEFT JOIN ALL_CONSTRAINTS D ON D.TABLE_NAME = A.TABLE_NAME AND D.CONSTRAINT_TYPE = 'P' AND D.OWNER = 'SHT' LEFT JOIN ALL_CONS_COLUMNS C ON C.CONSTRAINT_NAME = D.CONSTRAINT_NAME AND C.COLUMN_NAME=A.COLUMN_NAME AND C.OWNER = 'SHT'WHERE A.OWNER = 'SHT' AND A.TABLE_NAME = 'GOODS' ORDER BY A.COLUMN_ID 
2799 [main] DEBUG com.baomidou.mybatisplus.generator.config.querys.OracleQuery  - 返回记录数:15,耗时(ms):1633