2A W V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V V  V    V V V V * V * V   K K K    S  V V V * V V V      b  V       !"#$%&'()*+,-./0123456 789:;<=>?@ABCDEFGHIJKLMNOPQ R ST UV WXYZ [\]^_`abcdefghijklmnopqrstuv wxyz{|}~ V  W * * *  " " " "    V  V   V    V   "  V V DRIVER_NAMELjava/lang/String;DRIVER_VERSIONDRIVER_MAJOR_VERSIONIDRIVER_MINOR_VERSION LOB_MAXSIZELOB_MAXLENGTH_32BITJ connection'Loracle/jdbc/internal/OracleConnection;procedureResultUnknownprocedureNoResultprocedureReturnsResultprocedureColumnUnknownprocedureColumnInprocedureColumnInOutprocedureColumnOutprocedureColumnReturnprocedureColumnResultprocedureNoNullsprocedureNullableprocedureNullableUnknown columnNoNullscolumnNullablecolumnNullableUnknownbestRowTemporary ConstantValuebestRowTransactionbestRowSessionbestRowUnknownbestRowNotPseudo bestRowPseudoversionColumnUnknownversionColumnNotPseudoversionColumnPseudoimportedKeyCascadeimportedKeyRestrictimportedKeySetNull typeNoNulls typeNullabletypeNullableUnknown typePredNone typePredChar typePredBasictypeSearchabletableIndexStatisticStableIndexClusteredtableIndexHashedtableIndexOtherattributeNoNullsattributeNullableattributeNullableUnknown sqlStateXOpen sqlStateSQL99sqlWildcardRegexsqlWildcardPatternLjava/util/regex/Pattern;sqlEscapeRegexsqlEscapePattern+_Copyright_2007_Oracle_All_Rights_Reserved_ BUILD_DATETRACEZ!(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; getTypeInfo getIndexInfoN(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$autoCommitFailureClosesAllResultSetsgetClientInfoProperties getFunctions isWrapperFor(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+getPackagedProcedureColumnsNoWildcardsPlsqlgetOracleTypeMetaData4(Ljava/lang/String;)Loracle/jdbc/OracleTypeMetaData;()V SourceFileOracleDatabaseMetaData.java  d] e] f] g] h] i] j] k] l] m] n] o] p] q] r] }] ~] ] ] ] ] ] ] ] ] ] ] ]        ] ]  bc  Oracle  YZ [Z \] ^]".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 procedureSELECT -- 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    7$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 = 2select 'TABLE' as table_type from dual union select 'VIEW' as table_type from dual union select 'SYNONYM' as table_type from dual MZSELECT 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