Package | Description |
---|---|
oracle.pg.rdbms |
This package contains the APIs specific to the property graph support on Oracle Database.
|
oracle.pg.rdbms.pgql |
This package contains the APIs for executing PGQL on Oracle Database.
|
Modifier and Type | Method and Description |
---|---|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlExecution.executeQuery(int timeout, int parallel, long queryID, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlPreparedStatement.executeQuery(int timeout, int parallel, long queryID, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlExecution.executeQuery(java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlPreparedStatement.executeQuery(java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlExecution.executeQuery(java.lang.String pgql, int timeout, int parallel, long queryID, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlStatement.executeQuery(java.lang.String pgql, int timeout, int parallel, long queryID, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlExecution.executeQuery(java.lang.String pgql, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlResultSet |
OraclePgqlStatement.executeQuery(java.lang.String pgql, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlExecution.translateQuery(int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlPreparedStatement.translateQuery(int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlExecution.translateQuery(java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlPreparedStatement.translateQuery(java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlExecution.translateQuery(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlStatement.translateQuery(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlExecution.translateQuery(java.lang.String pgql, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
oracle.pg.rdbms.OraclePgqlSqlTrans |
OraclePgqlStatement.translateQuery(java.lang.String pgql, java.lang.String options)
Deprecated.
Translates this instance's PGQL statement into a SQL statement.
|
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
DbmsUtils.escapeAndEnquoteLiteral(java.lang.String str)
Does a SQL escape of single quotes and enquotes the literal
|
static java.lang.String |
DbmsUtils.escapeAndEnquoteLiteral(java.lang.String str, boolean forNVarchar)
Does a SQL escape of single quotes and enquotes the literal
|
default boolean |
PgqlPreparedStatement.execute()
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlExecution.execute(int parallel, int dynamicSampling, java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlPreparedStatement.execute(int parallel, int dynamicSampling, java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
default boolean |
PgqlStatement.execute(java.lang.String pgql)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlStatement.execute(java.lang.String pgql, int parallel, int dynamicSampling, java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlExecution.execute(java.lang.String pgql, int parallel, int dynamicSampling, java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlExecution.execute(java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlPreparedStatement.execute(java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlStatement.execute(java.lang.String pgql, java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
boolean |
PgqlExecution.execute(java.lang.String pgql, java.lang.String matchOptions, java.lang.String options)
Executes a PGQL Query, Modify or Create/Drop operation on this instance's property graph.
|
PgqlResultSet |
PgqlExecution.executeQuery()
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlPreparedStatement.executeQuery()
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlExecution.executeQuery(int timeout, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlPreparedStatement.executeQuery(int timeout, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
default PgqlResultSet |
PgqlStatement.executeQuery(java.lang.String pgql)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlStatement.executeQuery(java.lang.String pgql, int timeout, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlExecution.executeQuery(java.lang.String pgql, int timeout, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlStatement.executeQuery(java.lang.String pgql, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
PgqlResultSet |
PgqlExecution.executeQuery(java.lang.String pgql, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
|
oracle.pgql.lang.ir.QueryExpression.ExpressionType |
BindValueInfo.getBindVarType(oracle.pgql.lang.ir.QueryExpression.BindVariable bv)
Returns the value type for this bind variable determined from the set method previously used for this bind variable's parameter index.
|
java.lang.String |
PgqlConnection.getSchema()
Get the schema name that will be used to execute PGQL queries with this connection.
|
static java.lang.String |
DbmsUtils.sanitizeGraphName(java.sql.Connection conn, java.lang.String graphName)
Returns a sanitized version of graphName.
|
PgqlSqlTrans |
PgqlTranslator.translatePgql(java.lang.String pgqlStr, oracle.pgql.lang.ir.PgqlStatement stmt, BindValueInfo bvInfo)
Translates the given PGQL into a class containing SQL queries that can be used to perform query, insert/update/delete, create/drop on PG vertex and edge tables.
|
PgqlSqlTrans |
PgqlTranslator.translatePgql(java.lang.String pgqlStr, oracle.pgql.lang.ir.PgqlStatement stmt, BindValueInfo bvInfo, boolean forExecute)
Translates the given PGQL into a class containing SQL queries that can be used to perform query, insert/update/delete, create/drop on PG vertex and edge tables.
|
PgqlSqlQueryTrans |
PgqlExecution.translateQuery()
Translates this instance's PGQL statement into a SQL statement.
|
PgqlSqlQueryTrans |
PgqlPreparedStatement.translateQuery()
Translates this instance's PGQL statement into a SQL statement.
|
default PgqlSqlQueryTrans |
PgqlPreparedStatement.translateQuery(int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement.
|
default PgqlSqlQueryTrans |
PgqlStatement.translateQuery(java.lang.String pgql)
Translates this instance's PGQL statement into a SQL statement.
|
PgqlSqlQueryTrans |
PgqlTranslator.translateQuery(java.lang.String pgqlStr)
main query translation method
|
PgqlSqlQueryTrans |
PgqlTranslator.translateQuery(java.lang.String pgqlStr, BindValueInfo bvInfo)
main query translation method
|
PgqlSqlQueryTrans |
PgqlStatement.translateQuery(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement.
|
PgqlSqlQueryTrans |
PgqlExecution.translateQuery(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement.
|
PgqlSqlQueryTrans |
PgqlStatement.translateQuery(java.lang.String pgql, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement.
|
PgqlSqlQueryTrans |
PgqlExecution.translateQuery(java.lang.String pgql, java.lang.String options)
Translates this instance's PGQL statement into a SQL statement.
|
default PgqlSqlTrans |
PgqlPreparedStatement.translateStatement()
Translates this instance's PGQL statement into a series of SQL statements.
|
PgqlSqlTrans |
PgqlExecution.translateStatement(int parallel, int dynamicSampling, int maxResults, java.lang.String matchOptions, java.lang.String options) |
PgqlSqlTrans |
PgqlPreparedStatement.translateStatement(int parallel, int dynamicSampling, int maxResults, java.lang.String matchOptions, java.lang.String options)
Translates this instance's PGQL statement into a series of SQL statements.
|
default PgqlSqlTrans |
PgqlStatement.translateStatement(java.lang.String pgql)
Translates the given PGQL statement into a series of SQL statements.
|
PgqlSqlTrans |
PgqlStatement.translateStatement(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String matchOptions, java.lang.String options)
Translates the given PGQL statement into a series of SQL statements.
|
PgqlSqlTrans |
PgqlExecution.translateStatement(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String matchOptions, java.lang.String options) |
PgqlSqlTrans |
PgqlExecution.translateStatement(java.lang.String matchOptions, java.lang.String options) |
PgqlSqlTrans |
PgqlPreparedStatement.translateStatement(java.lang.String matchOptions, java.lang.String options)
Translates this instance's PGQL statement into a series of SQL statements.
|
PgqlSqlTrans |
PgqlStatement.translateStatement(java.lang.String pgql, java.lang.String matchOptions, java.lang.String options)
Translates the given PGQL statement into a series of SQL statements.
|
PgqlSqlTrans |
PgqlExecution.translateStatement(java.lang.String pgql, java.lang.String matchOptions, java.lang.String options) |
static java.lang.String |
PgqlUtils.unescapePgqlString(java.lang.String str)
Unescapes constant Strings in a PGQL query for matching against stored versions of the same constant.
|
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Aggregation.AggrAvg n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Aggregation.AggrCount n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Aggregation.AggrMax n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Aggregation.AggrMin n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Aggregation.AggrSum n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ArithmeticExpression.Add n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ArithmeticExpression.Div n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ArithmeticExpression.Mod n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ArithmeticExpression.Mul n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ArithmeticExpression.Sub n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ArithmeticExpression.UMin n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.BindVariable n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstBoolean n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstDate n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstDecimal n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstInteger n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstString n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstTime n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstTimestamp n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstTimestampWithTimezone n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Constant.ConstTimeWithTimezone n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ExtractExpression n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Function.Cast n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.Function.Exists n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.IfElse n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.IsNull n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.LogicalExpression.And n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.LogicalExpression.Not n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.LogicalExpression.Or n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.PropertyAccess n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.RelationalExpression.Equal n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.RelationalExpression.GreaterEqual n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.RelationalExpression.Greater n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.RelationalExpression.LessEqual n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.RelationalExpression.Less n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.RelationalExpression.NotEqual n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.ScalarSubquery n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visit(oracle.pgql.lang.ir.QueryExpression.VarRef n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitAllDifferent(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitContains(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitHasLabel(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitHasProp(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitId(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitInDegree(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitLabel(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitLabels(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
ExprTranslation |
ExprTransVisitor.visitOutDegree(oracle.pgql.lang.ir.QueryExpression.FunctionCall n, int[] childTypeFams, java.lang.String[][] childSQL, boolean isRoot, boolean negated) |
Copyright © 2010, 2020 Oracle and/or its affiliates. All Rights Reserved.