{"action":"created","issue":{"url":"https://api.github.com/repos/schemacrawler/SchemaCrawler/issues/215","repository_url":"https://api.github.com/repos/schemacrawler/SchemaCrawler","labels_url":"https://api.github.com/repos/schemacrawler/SchemaCrawler/issues/215/labels{/name}","comments_url":"https://api.github.com/repos/schemacrawler/SchemaCrawler/issues/215/comments","events_url":"https://api.github.com/repos/schemacrawler/SchemaCrawler/issues/215/events","html_url":"https://github.com/schemacrawler/SchemaCrawler/issues/215","id":375829667,"node_id":"MDU6SXNzdWUzNzU4Mjk2Njc=","number":215,"title":"can not get the columns of oracle table columns using schemacrawler-14.21.02","user":{"login":"zhanghuidouble","id":28583581,"node_id":"MDQ6VXNlcjI4NTgzNTgx","avatar_url":"https://avatars3.githubusercontent.com/u/28583581?v=4","gravatar_id":"","url":"https://api.github.com/users/zhanghuidouble","html_url":"https://github.com/zhanghuidouble","followers_url":"https://api.github.com/users/zhanghuidouble/followers","following_url":"https://api.github.com/users/zhanghuidouble/following{/other_user}","gists_url":"https://api.github.com/users/zhanghuidouble/gists{/gist_id}","starred_url":"https://api.github.com/users/zhanghuidouble/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhanghuidouble/subscriptions","organizations_url":"https://api.github.com/users/zhanghuidouble/orgs","repos_url":"https://api.github.com/users/zhanghuidouble/repos","events_url":"https://api.github.com/users/zhanghuidouble/events{/privacy}","received_events_url":"https://api.github.com/users/zhanghuidouble/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-10-31T07:19:24Z","updated_at":"2018-11-09T04:33:20Z","closed_at":"2018-11-07T01:49:32Z","author_association":"NONE","body":"# Environment\r\n\r\n> schemacrawler version:14.21.02\r\n>  jdk 1.8\r\n>  system:centOS\r\n> oracle server version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\n\r\n# Issue\r\nI want to get the columns of oracle table,but just receive  tablenames,no columns,check the code,I can see it runs function  **retrieveColumnsFromDataDictionary** in class **TableColumnRetriever.java**， the sql to get the columnsmetadata  returns null ：\r\n```\r\nSELECT  \r\n  NULL AS TABLE_CAT,\r\n  COLUMNS.OWNER AS TABLE_SCHEM,\r\n  COLUMNS.TABLE_NAME AS TABLE_NAME,\r\n  COLUMNS.COLUMN_NAME AS COLUMN_NAME,\r\n  DECODE(  \r\n  (SELECT A.TYPECODE \r\n     FROM ALL_TYPES A \r\n     WHERE A.TYPE_NAME = COLUMNS.DATA_TYPE\r\n     AND (A.OWNER = COLUMNS.OWNER OR A.OWNER IS NULL)), \r\n  'OBJECT', 2002, \r\n  'COLLECTION', 2003, \r\n  DECODE(substr(COLUMNS.data_type, 1, 9), \r\n    'TIMESTAMP', \r\n      DECODE(substr(COLUMNS.data_type, 10, 1), \r\n        '(', \r\n          DECODE(substr(COLUMNS.data_type, 19, 5), \r\n            'LOCAL', -102, 'TIME ', -101, 93), \r\n        DECODE(substr(COLUMNS.data_type, 16, 5), \r\n          'LOCAL', -102, 'TIME ', -101, 93)), \r\n    'INTERVAL ', \r\n      DECODE(substr(COLUMNS.data_type, 10, 3), \r\n       'DAY', -104, 'YEA', -103), \r\n    DECODE(COLUMNS.data_type, \r\n      'BINARY_DOUBLE', 101, \r\n      'BINARY_FLOAT', 100, \r\n      'BFILE', -13, \r\n      'BLOB', 2004, \r\n      'CHAR', 1, \r\n      'CLOB', 2005, \r\n      'COLLECTION', 2003, \r\n      'DATE', 93, \r\n      'FLOAT', 6, \r\n      'LONG', -1, \r\n      'LONG RAW', -4, \r\n      'NCHAR', -15, \r\n      'NCLOB', 2011, \r\n      'NUMBER', 3, \r\n      'NVARCHAR', -9, \r\n      'NVARCHAR2', -9, \r\n      'OBJECT', 2002, \r\n      'OPAQUE/XMLTYPE', 2009, \r\n      'RAW', -3, \r\n      'REF', 2006, \r\n      'ROWID', -8, \r\n      'SQLXML', 2009, \r\n      'UROWID', -8, \r\n      'VARCHAR2', 12, \r\n      'VARRAY', 2003, \r\n      'XMLTYPE', 2009, \r\n      1111)))\r\n  AS DATA_TYPE,\r\n  COLUMNS.DATA_TYPE AS TYPE_NAME,\r\n  DECODE (COLUMNS.DATA_PRECISION, NULL, DECODE(COLUMNS.DATA_TYPE, 'NUMBER', DECODE(COLUMNS.DATA_SCALE, NULL, 0 , 38), DECODE (COLUMNS.DATA_TYPE, 'CHAR', COLUMNS.CHAR_LENGTH, 'VARCHAR', COLUMNS.CHAR_LENGTH, 'VARCHAR2', COLUMNS.CHAR_LENGTH, 'NVARCHAR2', COLUMNS.CHAR_LENGTH, 'NCHAR', COLUMNS.CHAR_LENGTH, 'NUMBER', 0, COLUMNS.DATA_LENGTH) ), COLUMNS.DATA_PRECISION)\r\n  AS COLUMN_SIZE,\r\n  0 AS BUFFER_LENGTH,\r\n  DECODE (COLUMNS.DATA_TYPE, 'NUMBER', DECODE(COLUMNS.DATA_PRECISION, NULL, DECODE(COLUMNS.DATA_SCALE, NULL, -127 , COLUMNS.DATA_SCALE), COLUMNS.DATA_SCALE), COLUMNS.DATA_SCALE) \r\n  AS DECIMAL_DIGITS,\r\n  10 AS NUM_PREC_RADIX,\r\n  DECODE (COLUMNS.NULLABLE, 'N', 0, 1) AS NULLABLE,\r\n  REMARKS.COMMENTS AS REMARKS,\r\n  COLUMNS.DATA_DEFAULT AS COLUMN_DEF,\r\n  0 AS SQL_DATA_TYPE,\r\n  0 AS SQL_DATETIME_SUB,\r\n  COLUMNS.DATA_LENGTH AS CHAR_OCTET_LENGTH,\r\n  COLUMNS.COLUMN_ID AS ORDINAL_POSITION,\r\n  DECODE (COLUMNS.NULLABLE, 'N', 'NO', 'YES') AS IS_NULLABLE,\r\n  NULL AS SCOPE_CATALOG,\r\n  NULL AS SCOPE_SCHEMA,\r\n  NULL AS SCOPE_TABLE,\r\n  NULL AS SOURCE_DATA_TYPE,\r\n  'NO' AS IS_AUTOINCREMENT,\r\n  'NO' AS IS_GENERATEDCOLUMN\r\nFROM \r\n  ALL_TAB_COLS COLUMNS\r\n  LEFT OUTER JOIN ALL_COL_COMMENTS REMARKS\r\n    ON \r\n      COLUMNS.OWNER = REMARKS.OWNER \r\n      AND COLUMNS.TABLE_NAME = REMARKS.TABLE_NAME \r\n      AND COLUMNS.COLUMN_NAME = REMARKS.COLUMN_NAME  \r\nWHERE\r\n  COLUMNS.OWNER NOT IN \r\n    ('ANONYMOUS', 'APEX_PUBLIC_USER', 'APPQOSSYS', 'BI', 'CTXSYS', 'DBSNMP', 'DIP', \r\n    'EXFSYS', 'FLOWS_30000', 'FLOWS_FILES', 'IX', 'LBACSYS', \r\n    'MDDATA', 'MDSYS', 'MGMT_VIEW', 'OE', 'OLAPSYS', 'ORACLE_OCM', \r\n    'ORDPLUGINS', 'ORDSYS', 'OUTLN', 'OWBSYS', 'PM', 'SCOTT', 'SH', \r\n    'SI_INFORMTN_SCHEMA', 'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR', \r\n    'SYS', 'SYSMAN', 'SYSTEM', 'TSMSYS', 'WKPROXY', 'WKSYS', 'WK_TEST', \r\n    'WMSYS', 'XDB', 'XS$NULL', 'RDSADMIN')  \r\n  AND NOT REGEXP_LIKE(COLUMNS.OWNER, '^APEX_[0-9]{6}$')\r\n  AND NOT REGEXP_LIKE(COLUMNS.OWNER, '^FLOWS_[0-9]{5,6}$')\r\n  AND REGEXP_LIKE(COLUMNS.OWNER, '${schemas}')\r\n  AND COLUMNS.TABLE_NAME NOT LIKE 'BIN$%'\r\n  AND NOT REGEXP_LIKE(COLUMNS.TABLE_NAME, '^(SYS_IOT|MDOS|MDRS|MDRT|MDOT|MDXT)_.*$')\r\nORDER BY \r\n  TABLE_SCHEM, \r\n  TABLE_NAME, \r\n  ORDINAL_POSITION\r\n```"},"comment":{"url":"https://api.github.com/repos/schemacrawler/SchemaCrawler/issues/comments/437247144","html_url":"https://github.com/schemacrawler/SchemaCrawler/issues/215#issuecomment-437247144","issue_url":"https://api.github.com/repos/schemacrawler/SchemaCrawler/issues/215","id":437247144,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNzI0NzE0NA==","user":{"login":"zhanghuidouble","id":28583581,"node_id":"MDQ6VXNlcjI4NTgzNTgx","avatar_url":"https://avatars3.githubusercontent.com/u/28583581?v=4","gravatar_id":"","url":"https://api.github.com/users/zhanghuidouble","html_url":"https://github.com/zhanghuidouble","followers_url":"https://api.github.com/users/zhanghuidouble/followers","following_url":"https://api.github.com/users/zhanghuidouble/following{/other_user}","gists_url":"https://api.github.com/users/zhanghuidouble/gists{/gist_id}","starred_url":"https://api.github.com/users/zhanghuidouble/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhanghuidouble/subscriptions","organizations_url":"https://api.github.com/users/zhanghuidouble/orgs","repos_url":"https://api.github.com/users/zhanghuidouble/repos","events_url":"https://api.github.com/users/zhanghuidouble/events{/privacy}","received_events_url":"https://api.github.com/users/zhanghuidouble/received_events","type":"User","site_admin":false},"created_at":"2018-11-09T04:33:20Z","updated_at":"2018-11-09T04:33:20Z","author_association":"NONE","body":"sorry，forgot to comment,I found it is not problem of SchemaCrawler ,is user privileage cause.Thanks."}}
{"actor":{"display_login":"zhanghuidouble"}}