-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathOracle_template
7 lines (6 loc) · 903 Bytes
/
Oracle_template
1
2
3
4
5
6
7
TABLE_INFO_QUERY=select USER_TABLES.TABLE_NAME, USER_TAB_COMMENTS.COMMENTS from USER_TABLES, USER_TAB_COMMENTS where USER_TABLES.TABLE_NAME = USER_TAB_COMMENTS.TABLE_NAME order by USER_TABLES.TABLE_NAME
COLUMN_INFO_QUERY=select USER_TAB_COLUMNS.COLUMN_NAME, USER_COL_COMMENTS.COMMENTS, USER_TAB_COLUMNS.DATA_TYPE, USER_TAB_COLUMNS.DATA_LENGTH, USER_TAB_COLUMNS.DATA_PRECISION, USER_TAB_COLUMNS.DATA_SCALE, USER_TAB_COLUMNS.NULLABLE, USER_TAB_COLUMNS.COLUMN_ID, USER_TAB_COLUMNS.DATA_DEFAULT, USER_TAB_COLUMNS.CHAR_LENGTH from USER_TAB_COLUMNS, USER_COL_COMMENTS where USER_TAB_COLUMNS.TABLE_NAME = '%TABLE_NAME%' and USER_TAB_COLUMNS.TABLE_NAME = USER_COL_COMMENTS.TABLE_NAME and USER_TAB_COLUMNS.COLUMN_NAME = USER_COL_COMMENTS.COLUMN_NAME
COLUMN_INFO_QUERY.TABLE_NAME_REPLACER=%TABLE_NAME%
DRIVER_NAME=oracle.jdbc.driver.OracleDriver
CONNECTION_CHECK_SQL=select 1 from dual
SQL_COMMENT_OUT=--