Interface JSONTableColumnPathStep

All Superinterfaces:

Fields, GroupField, JSONTableColumnForOrdinalityStep, JSONTableColumnsFirstStep, JSONTableColumnsStep, Named, Qualified, QueryPart, RecordQualifier<Record>, SelectField<Record>, SelectFieldOrAsterisk, Serializable, Table<Record>, TableLike<Record>, Typed<Record>

public interface JSONTableColumnPathStep
extends JSONTableColumnForOrdinalityStep, JSONTableColumnsStep

A step in the construction of an JSON_TABLE expression.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull JSONTableColumnsStep	path(String path)	Specify the PATH of a column in the COLUMNS clause of the JSON_TABLE predicate.

Methods inherited from interface Fields

dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsIncludingHidden, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types

Methods inherited from interface JSONTableColumnForOrdinalityStep

forOrdinality

Methods inherited from interface JSONTableColumnsFirstStep

column, column, column, column, column, column

Methods inherited from interface Named

$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface Qualified

$schema, getCatalog, getSchema

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface RecordQualifier

getDataType, getPackage, getRecordType, newRecord

Methods inherited from interface SelectField

as, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo

Methods inherited from interface Table

as, as, as, as, as, as, as, as, as, as, as, as, as, as, as, asOfScn, asOfScn, asOfTimestamp, asOfTimestamp, asterisk, at, at, at, crossApply, crossApply, crossApply, crossApply, crossApply, crossApply, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, eq, equal, equals, for_, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, forPortionOf, from, fullHashJoin, fullHashJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullLoopJoin, fullLoopJoin, fullMergeJoin, fullMergeJoin, fullOuterHashJoin, fullOuterHashJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterLoopJoin, fullOuterLoopJoin, fullOuterMergeJoin, fullOuterMergeJoin, getChecks, getIdentity, getIndexes, getKeys, getOptions, getPrimaryKey, getRecordTimestamp, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getTableType, getTriggers, getUniqueKeys, hashJoin, hashJoin, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerHashJoin, innerHashJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerLoopJoin, innerLoopJoin, innerMergeJoin, innerMergeJoin, join, join, join, join, join, join, join, join, join, leftAntiJoin, leftAntiJoin, leftHashJoin, leftHashJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftLoopJoin, leftLoopJoin, leftMergeJoin, leftMergeJoin, leftOuterHashJoin, leftOuterHashJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterLoopJoin, leftOuterLoopJoin, leftOuterMergeJoin, leftOuterMergeJoin, leftSemiJoin, leftSemiJoin, loopJoin, loopJoin, mergeJoin, mergeJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, ne, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, partitionBy, partitionBy, pivot, pivot, pivot, recordType, rightHashJoin, rightHashJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightLoopJoin, rightLoopJoin, rightMergeJoin, rightMergeJoin, rightOuterHashJoin, rightOuterHashJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterLoopJoin, rightOuterLoopJoin, rightOuterMergeJoin, rightOuterMergeJoin, rowid, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, tablesample, tablesample, tablesampleBernoulli, tablesampleBernoulli, tablesampleSystem, tablesampleSystem, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, versionsBetweenScn, versionsBetweenScn, versionsBetweenScnMinvalue, versionsBetweenTimestamp, versionsBetweenTimestamp, versionsBetweenTimestampMinvalue, where, where, where, where, where, where, where, where, whereExists, whereNotExists, with, with, with, with, withOrdinality

Methods inherited from interface TableLike

asMultiset, asMultiset, asMultiset, asMultiset, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable

Methods inherited from interface Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

path

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnsStep path(String path)

Specify the PATH of a column in the COLUMNS clause of the JSON_TABLE predicate.