oracle.jdbc.OracleDatabaseMetaData.class Maven / Gradle / Ivy

????29
V?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U?	U???	U????????	U?	U?	U?	U??????????????????????
*?
U?
*?
U?
??
??
K?
K??
K????????S???
U?
U?
U?
*?
U?
U?
U????????????b???
U????????????	

 !"#$%&'()*+,-./0123?456789:;<=>?@ABCDEFGHIJKLMN?O?PQ?RSTUVW
?XYZ[\]^_`abcdefghijklmnopqrs?tuvwxyz{|}~?????????????????????????????
U??
?????T?
*?
*?
*????????????
??
"??
"???
"?
"??
??????????????	U?	??
U????????
??
??	U??
??
??
??	U?
??
??
"????????????	U?????	U????DRIVER_NAMELjava/lang/String;DRIVER_VERSIONDRIVER_MAJOR_VERSIONIDRIVER_MINOR_VERSIONLOB_MAXSIZELOB_MAXLENGTH_32BITJ
connection'Loracle/jdbc/internal/OracleConnection;procedureResultUnknownprocedureNoResultprocedureReturnsResultprocedureColumnUnknownprocedureColumnInprocedureColumnInOutprocedureColumnOutprocedureColumnReturnprocedureColumnResultprocedureNoNullsprocedureNullableprocedureNullableUnknown
columnNoNullscolumnNullablecolumnNullableUnknownbestRowTemporary
ConstantValuebestRowTransactionbestRowSessionbestRowUnknownbestRowNotPseudo
bestRowPseudoversionColumnUnknownversionColumnNotPseudoversionColumnPseudoimportedKeyCascadeimportedKeyRestrictimportedKeySetNulltypeNoNullstypeNullabletypeNullableUnknowntypePredNonetypePredChar
typePredBasictypeSearchabletableIndexStatisticStableIndexClusteredtableIndexHashedtableIndexOtherattributeNoNullsattributeNullableattributeNullableUnknown
sqlStateXOpen
sqlStateSQL99sqlWildcardRegexsqlWildcardPatternLjava/util/regex/Pattern;sqlEscapeRegexsqlEscapePattern+_Copyright_2007_Oracle_All_Rights_Reserved_
BUILD_DATE?TRACEZ!(Loracle/jdbc/OracleConnection;)VCodeLineNumberTable
DeprecatedallProceduresAreCallable()Z
ExceptionsallTablesAreSelectablegetURL()Ljava/lang/String;getUserName
isReadOnlynullsAreSortedHighnullsAreSortedLownullsAreSortedAtStartnullsAreSortedAtEndgetDatabaseProductNamegetDatabaseProductVersion
getDriverNamegetDriverVersiongetDriverMajorVersion()IgetDriverMinorVersionusesLocalFilesusesLocalFilePerTablesupportsMixedCaseIdentifiersstoresUpperCaseIdentifiersstoresLowerCaseIdentifiersstoresMixedCaseIdentifiers"supportsMixedCaseQuotedIdentifiers storesUpperCaseQuotedIdentifiers storesLowerCaseQuotedIdentifiers storesMixedCaseQuotedIdentifiersgetIdentifierQuoteStringgetSQLKeywordsgetNumericFunctionsgetStringFunctionsgetSystemFunctionsgetTimeDateFunctionsgetSearchStringEscapegetExtraNameCharacterssupportsAlterTableWithAddColumn supportsAlterTableWithDropColumnsupportsColumnAliasingnullPlusNonNullIsNullsupportsConvert(II)ZsupportsTableCorrelationNames&supportsDifferentTableCorrelationNamessupportsExpressionsInOrderBysupportsOrderByUnrelatedsupportsGroupBysupportsGroupByUnrelatedsupportsGroupByBeyondSelectsupportsLikeEscapeClausesupportsMultipleResultSetssupportsMultipleTransactionssupportsNonNullableColumnssupportsMinimumSQLGrammarsupportsCoreSQLGrammarsupportsExtendedSQLGrammarsupportsANSI92EntryLevelSQLsupportsANSI92IntermediateSQLsupportsANSI92FullSQL$supportsIntegrityEnhancementFacilitysupportsOuterJoinssupportsFullOuterJoinssupportsLimitedOuterJoins
getSchemaTermgetProcedureTermgetCatalogTermisCatalogAtStartgetCatalogSeparator!supportsSchemasInDataManipulationsupportsSchemasInProcedureCalls!supportsSchemasInTableDefinitions!supportsSchemasInIndexDefinitions%supportsSchemasInPrivilegeDefinitions"supportsCatalogsInDataManipulation supportsCatalogsInProcedureCalls"supportsCatalogsInTableDefinitions"supportsCatalogsInIndexDefinitions&supportsCatalogsInPrivilegeDefinitionssupportsPositionedDeletesupportsPositionedUpdatesupportsSelectForUpdatesupportsStoredProceduressupportsSubqueriesInComparisonssupportsSubqueriesInExistssupportsSubqueriesInInssupportsSubqueriesInQuantifiedssupportsCorrelatedSubqueries
supportsUnionsupportsUnionAllsupportsOpenCursorsAcrossCommit!supportsOpenCursorsAcrossRollback"supportsOpenStatementsAcrossCommit$supportsOpenStatementsAcrossRollbackgetMaxBinaryLiteralLengthgetMaxCharLiteralLengthgetMaxColumnNameLengthgetMaxColumnsInGroupBygetMaxColumnsInIndexgetMaxColumnsInOrderBygetMaxColumnsInSelectgetMaxColumnsInTablegetMaxConnectionsgetMaxCursorNameLengthgetMaxIndexLengthgetMaxSchemaNameLengthgetMaxProcedureNameLengthgetMaxCatalogNameLength
getMaxRowSizedoesMaxRowSizeIncludeBlobsgetMaxStatementLengthgetMaxStatementsgetMaxTableNameLengthgetMaxTablesInSelectgetMaxUserNameLengthgetDefaultTransactionIsolationsupportsTransactions!supportsTransactionIsolationLevel(I)Z
StackMapTable5supportsDataDefinitionAndDataManipulationTransactions(supportsDataManipulationTransactionsOnly%dataDefinitionCausesTransactionCommit#dataDefinitionIgnoredInTransactions
getProceduresL(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;???getProcedureColumns^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;?(getUnpackagedProcedureColumnsNoWildcards?????&getPackagedProcedureColumnsNoWildcards getProcedureColumnsWithWildcards_(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Z)Ljava/sql/ResultSet;?getFunctionColumns	getTables_(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet;??
getSchemas()Ljava/sql/ResultSet;getCatalogs
getTableTypes
getColumnsgetColumnPrivilegesgetTablePrivilegesgetBestRowIdentifierN(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;IZ)Ljava/sql/ResultSet;?getVersionColumnsgetPrimaryKeys
keys_queryp(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;getImportedKeysgetExportedKeysgetCrossReference?(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;getTypeInfogetIndexInfoN(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ZZ)Ljava/sql/ResultSet;?fail()Ljava/sql/SQLException;supportsResultSetTypesupportsResultSetConcurrencyownUpdatesAreVisibleownDeletesAreVisibleownInsertsAreVisibleothersUpdatesAreVisibleothersDeletesAreVisibleothersInsertsAreVisibleupdatesAreDetecteddeletesAreDetectedinsertsAreDetectedsupportsBatchUpdatesgetUDTsN(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[I)Ljava/sql/ResultSet;?
getConnection()Ljava/sql/Connection;supportsSavepointssupportsNamedParameterssupportsMultipleOpenResultssupportsGetGeneratedKeys
getSuperTypesgetSuperTables
getAttributessupportsResultSetHoldabilitygetResultSetHoldabilitygetDatabaseMajorVersiongetDatabaseMinorVersiongetJDBCMajorVersiongetJDBCMinorVersiongetSQLStateTypelocatorsUpdateCopysupportsStatementPoolinggetDriverNameInfogetDriverVersionInfogetDriverMajorVersionInfogetDriverMinorVersionInfogetLobPrecisiongetLobMaxLength()JgetRowIdLifetime()Ljava/sql/RowIdLifetime;:(Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;&supportsStoredFunctionsUsingCallSyntax$autoCommitFailureClosesAllResultSetsgetClientInfoPropertiesgetFunctionsisWrapperFor(Ljava/lang/Class;)Z	Signature(Ljava/lang/Class<*>;)Zunwrap%(Ljava/lang/Class;)Ljava/lang/Object;1(Ljava/lang/Class;)TT;$getConnectionDuringExceptionHandling)()Loracle/jdbc/internal/OracleConnection;hasSqlWildcard(Ljava/lang/String;)ZstripSqlEscapes&(Ljava/lang/String;)Ljava/lang/String;?-getUnpackagedProcedureColumnsNoWildcardsPlsql+getPackagedProcedureColumnsNoWildcardsPlsql()V
SourceFileOracleDatabaseMetaData.java??c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\|\}\~\\?\?\?\?\?\?\?\?\?\???????????????\?\???ab?????Oracle??XYZY[\]\".ACCESS, ADD, ALTER, AUDIT, CLUSTER, COLUMN, COMMENT, COMPRESS, CONNECT, DATE, DROP, EXCLUSIVE, FILE, IDENTIFIED, IMMEDIATE, INCREMENT, INDEX, INITIAL, INTERSECT, LEVEL, LOCK, LONG, MAXEXTENTS, MINUS, MODE, NOAUDIT, NOCOMPRESS, NOWAIT, NUMBER, OFFLINE, ONLINE, PCTFREE, PRIOR, all_PL_SQL_reserved_ wordsfABS,ACOS,ASIN,ATAN,ATAN2,CEILING,COS,EXP,FLOOR,LOG,LOG10,MOD,PI,POWER,ROUND,SIGN,SIN,SQRT,TAN,TRUNCATEtASCII,CHAR,CHAR_LENGTH,CHARACTER_LENGTH,CONCAT,LCASE,LENGTH,LTRIM,OCTET_LENGTH,REPLACE,RTRIM,SOUNDEX,SUBSTRING,UCASEUSERLCURRENT_DATE,CURRENT_TIMESTAMP,CURDATE,EXTRACT,HOUR,MINUTE,MONTH,SECOND,YEAR/$#schema	procedure?SELECT
  -- Standalone procedures and functions
  NULL AS procedure_cat,
  owner AS procedure_schem,
  object_name AS procedure_name,
  NULL,
  NULL,
  NULL,
  'Standalone procedure or function' AS remarks,
  DECODE(object_type, 'PROCEDURE', 1,
                      'FUNCTION', 2,
                      0) AS procedure_type
,  NULL AS specific_name
FROM all_objects
WHERE (object_type = 'PROCEDURE' OR object_type = 'FUNCTION')
  AND owner LIKE :1 ESCAPE '/'
  AND object_name LIKE :2 ESCAPE '/'
GSELECT
  -- Packaged procedures with no arguments
  package_name AS procedure_cat,
  owner AS procedure_schem,
  object_name AS procedure_name,
  NULL,
  NULL,
  NULL,
  'Packaged procedure' AS remarks,
  1 AS procedure_type
,  NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NULL
  AND data_type IS NULL
  AND ]SELECT
  -- Packaged procedures with arguments
  package_name AS procedure_cat,
  owner AS procedure_schem,
  object_name AS procedure_name,
  NULL,
  NULL,
  NULL,
  'Packaged procedure' AS remarks,
  1 AS procedure_type
,  NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NOT NULL
  AND position = 1
  AND position = sequence
  AND GSELECT
  -- Packaged functions
  package_name AS procedure_cat,
  owner AS procedure_schem,
  object_name AS procedure_name,
  NULL,
  NULL,
  NULL,
  'Packaged function' AS remarks,
  2 AS procedure_type
,  NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NULL
  AND in_out = 'OUT'
  AND   data_level = 0
  AND dpackage_name LIKE :3 ESCAPE '/'
  AND owner LIKE :4 ESCAPE '/'
  AND object_name LIKE :5 ESCAPE '/'
]package_name IS NOT NULL
  AND owner LIKE :6 ESCAPE '/'
  AND object_name LIKE :7 ESCAPE '/'
)ORDER BY procedure_schem, procedure_name
%???????????java/lang/StringBuilder??
UNION ALL ??????6$oracle/jdbc/internal/OracleResultSet??????&?,$-.???	?
#oracle/jdbc/OracleCallableStatement
???>SELECT package_name AS procedure_cat,
       owner AS procedure_schem,
       object_name AS procedure_name,
       argument_name AS column_name,
       DECODE(position, 0, 5,
                        DECODE(in_out, 'IN', 1,
                                       'OUT', 4,
                                       'IN/OUT', 2,
                                       0)) AS column_type,
       DECODE (data_type, 'CHAR', 1,
                          'VARCHAR2', 12,
                          'NUMBER', 3,
                          'LONG', -1,
                          'DATE', ?93,
91,
%                          'RAW', -3,
*                          'LONG RAW', -4,
,                          'TIMESTAMP', 93, 
=                          'TIMESTAMP WITH TIME ZONE', -101, 
8               'TIMESTAMP WITH LOCAL TIME ZONE', -102, 
0               'INTERVAL YEAR TO MONTH', -103, 
0               'INTERVAL DAY TO SECOND', -104, 
:               'BINARY_FLOAT', 100, 'BINAvRY_DOUBLE', 101,#               1111) AS data_type,
C       DECODE(data_type, 'OBJECT', type_owner || '.' || type_name, '              data_type) AS type_name,
2       DECODE (data_precision, NULL, data_length,
=                               data_precision) AS precision,
       data_length AS length,
       data_scale AS scale,
       10 AS radix,
       1 AS nullable,
       NULL AS remarks,
$       default_value AS column_def,
       NULL as sql_data_type,
!       NULL AS sql_datetime_sub,
       DECODE(data_type,
(                         'CHAR', 32767,
,                         'VARCHAR2', 32767,
(                         'LONG', 32767,
'                         'RAW', 32767,
,                         'LONG RAW', 32767,
5                         NULL) AS char_octet_length,
+       (sequence - 1) AS ordinal_position,
       'YES' AS is_nullable,
       NULL AS specific_name,
       sequence,
       overload,
       default_value
 FROM all_arguments
WHERE owner LIKE :1 ESCAPE '/'
8  AND object_name LIKE :2 ESCAPE '/' AND data_level = 0
&  AND package_name LIKE :3 ESCAPE '/'
  AND package_name IS NULL
'  AND argument_name LIKE :4 ESCAPE '/'
p  AND (argument_name LIKE :5 ESCAPE '/'
       OR (argument_name IS NULL
           AND data_type IS NOT NULL))
=ORDER BY procedure_schem, procedure_name, overload, sequence
SSELECT package_name AS function_cat,
       arg.owner AS function_schem,
       arg.object_name AS function_name,
       arg.argument_name AS column_name,
       DECODE(arg.position, 0, 5,
                        DECODE(arg.in_out, 'IN', 1,
                                       'OUT', 4,
                                       'IN/OUT', 2,
                                       0)) AS column_type,
       DECODE (arg.data_type, 'CHAR', 1,
                          'VARCHAR2', 12,
                          'NUMBER', 3,
                          'LONG', -1,
                          'DATE', O       DECODE(arg.data_type, 'OBJECT', arg.type_owner || '.' || arg.type_name, +              arg.data_type) AS type_name,
:       DECODE (arg.data_precision, NULL, arg.data_length,
A                               arg.data_precision) AS precision,
"       arg.data_length AS length,
        arg.data_scale AS scale,
(       arg.default_value AS column_def,
       DECODE(arg.data_type,
/       (arg.sequence - 1) AS ordinal_position,
       arg.sequence,
       arg.overload,
       arg.default_value
- FROM all_arguments arg, all_procedures proc
$ WHERE arg.owner LIKE :1 ESCAPE '/'
)  AND arg.object_name LIKE :2 ESCAPE '/'
I  AND proc.object_id = arg.object_id
  AND proc.object_type = 'FUNCTION'
F  AND proc.owner = arg.owner
  AND proc.object_name = arg.object_name
*  AND arg.package_name LIKE :3 ESCAPE '/'
  AND arg.package_name IS NULL
+  AND arg.argument_name LIKE :4 ESCAPE '/'
x  AND (arg.argument_name LIKE :5 ESCAPE '/'
     OR (arg.argument_name IS NULL
         AND arg.data_type IS NOT NULL))
;ORDER BY function_schem, function_name, overload, sequence
?SELECT NULL AS table_cat,
       o.owner AS table_schem,
       o.object_name AS table_name,
       o.object_type AS table_type,
       c.comments AS remarks
       NULL AS remarks
)  FROM all_objects o, all_tab_comments c
  FROM all_objects o
L  WHERE o.owner LIKE :1 ESCAPE '/'
    AND o.object_name LIKE :2 ESCAPE '/'
G    AND o.owner = c.owner (+)
    AND o.object_name = c.table_name (+)
    AND o.object_type IN ('xxx'SYNONYM, '')
6    AND o.object_type IN ('TABLE', 'SYNONYM', 'VIEW')
+    AND o.object_type IN ('TABLE', 'VIEW')
/  ORDER BY table_type, table_schem, table_name
?SELECT NULL AS table_cat,
       s.owner AS table_schem,
       s.synonym_name AS table_name,
       'SYNONYM' AS table_table_type,
9  FROM all_synonyms s, all_objects o, all_tab_comments c
%  FROM all_synonyms s, all_objects o
?  WHERE s.owner LIKE :3 ESCAPE '/'
    AND s.synonym_name LIKE :4 ESCAPE '/'
    AND s.table_owner = o.owner
    AND s.table_name = o.object_name
    AND o.object_type IN ('TABLE', 'VIEW')
??UNION
BSELECT username AS table_schem FROM all_users ORDER BY table_schem?3select 'nothing' as table_cat from dual where 1 = 2?select 'TABLE' as table_type from dual
union select 'VIEW' as table_type from dual
union select 'SYNONYM' as table_type from dual
LZSELECT NULL AS table_cat,
       table_schema AS table_schem,
       table_name,
       column_name,
       grantor,
       grantee,
       privilege,
       grantable AS is_grantable
FROM all_col_privs
WHERE table_schema LIKE :1 ESCAPE '/'
  AND table_name LIKE :2 ESCAPE '/'
  AND column_name LIKE :3 ESCAPE '/'
ORDER BY column_name, privilege
-SELECT NULL AS table_cat,
       table_schema AS table_schem,
       table_name,
       grantor,
       grantee,
       privilege,
       grantable AS is_grantable
FROM all_tab_privs
WHERE table_schema LIKE :1 ESCAPE '/'
  AND table_name LIKE :2 ESCAPE '/'
ORDER BY table_schem, table_name, privilege