Module org.jooq

Package org.jooq

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 org.jooq.Fields

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

Methods inherited from interface org.jooq.JSONTableColumnForOrdinalityStep

forOrdinality

Methods inherited from interface org.jooq.JSONTableColumnsFirstStep

column, column, column, column, column, column

Methods inherited from interface org.jooq.Named

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

Methods inherited from interface org.jooq.Qualified

$schema, getCatalog, getSchema

Methods inherited from interface org.jooq.QueryPart

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

Methods inherited from interface org.jooq.RecordQualifier

getDataType, getPackage, getRecordType, newRecord

Methods inherited from interface org.jooq.SelectField

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

Methods inherited from interface org.jooq.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, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, getChecks, getIdentity, getIndexes, getKeys, getOptions, getPrimaryKey, getRecordTimestamp, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getTableType, getUniqueKeys, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, join, join, leftAntiJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftSemiJoin, 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, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rowid, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, versionsBetweenScn, versionsBetweenScn, versionsBetweenScnMinvalue, versionsBetweenTimestamp, versionsBetweenTimestamp, versionsBetweenTimestampMinvalue, where, where, where, where, where, where, where, where, whereExists, whereNotExists, with, with, with, with

Methods inherited from interface org.jooq.TableLike

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

Methods inherited from interface org.jooq.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.