Module org.jooq

Package org.jooq

Interface JSONTableColumnsFirstStep

All Known Subinterfaces:

JSONTableColumnPathStep, JSONTableColumnsStep

public interface JSONTableColumnsFirstStep

A step in the construction of an JSON_TABLE expression.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull JSONTableColumnForOrdinalityStep	column(String name)	Add a column to the COLUMNS clause of the JSON_TABLE expression.
@NotNull JSONTableColumnPathStep	column(String name, DataType<?> type)	Add a column to the COLUMNS clause of the JSON_TABLE expression.
@NotNull JSONTableColumnPathStep	column(Field<?> name)	Add a column to the COLUMNS clause of the JSON_TABLE expression.
@NotNull JSONTableColumnPathStep	column(Field<?> name, DataType<?> type)	Add a column to the COLUMNS clause of the JSON_TABLE expression.
@NotNull JSONTableColumnForOrdinalityStep	column(Name name)	Add a column to the COLUMNS clause of the JSON_TABLE expression.
@NotNull JSONTableColumnPathStep	column(Name name, DataType<?> type)	Add a column to the COLUMNS clause of the JSON_TABLE expression.

Method Details

column

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnForOrdinalityStep column(String name)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

column

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnForOrdinalityStep column(Name name)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

column

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnPathStep column(Field<?> name)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

column

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnPathStep column(String name,
 DataType<?> type)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

column

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnPathStep column(Name name,
 DataType<?> type)

Add a column to the COLUMNS clause of the JSON_TABLE expression.

column

@NotNull
@Support({DB2_11,HANA,MARIADB_10_6,MYSQL_8_0_19,ORACLE12C,POSTGRES_12,SQLSERVER2016,YUGABYTEDB})
@NotNull JSONTableColumnPathStep column(Field<?> name,
 DataType<?> type)

Add a column to the COLUMNS clause of the JSON_TABLE expression.