Module org.jooq

Package org.jooq

Interface CreateViewAsStep<R extends Record>

public interface CreateViewAsStep<R extends Record>

A Query that can create views.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

• They're operating on mutable implementations (as of jOOQ 3.x)
• They're less composable and not easy to get right when dynamic SQL gets complex
• They're less readable
• They might have binary incompatible changes between minor releases

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
CreateViewFinalStep	as(String sql)	Add an AS clause to the CREATE VIEW statement.
CreateViewFinalStep	as(String sql, Object... bindings)	Add an AS clause to the CREATE VIEW statement.
CreateViewFinalStep	as(String sql, QueryPart... parts)	Add an AS clause to the CREATE VIEW statement.
CreateViewFinalStep	as(Select<? extends R> select)	Add an AS clause to the CREATE VIEW statement.
CreateViewFinalStep	as(SQL sql)	Add an AS clause to the CREATE VIEW statement.

Method Detail

as

@Support
CreateViewFinalStep as(Select<? extends R> select)

Add an AS clause to the CREATE VIEW statement.

as

@Support
@PlainSQL
CreateViewFinalStep as(SQL sql)

Add an AS clause to the CREATE VIEW statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Parameters:

sql - The SQL

See Also:

SQL

as

@Support
@PlainSQL
CreateViewFinalStep as(String sql)

Add an AS clause to the CREATE VIEW statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Parameters:

sql - The SQL

See Also:

SQL

as

@Support
@PlainSQL
CreateViewFinalStep as(String sql,
                       Object... bindings)

Add an AS clause to the CREATE VIEW statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Parameters:

sql - The SQL

See Also:

SQL

as

@Support
@PlainSQL
CreateViewFinalStep as(String sql,
                       QueryPart... parts)

Add an AS clause to the CREATE VIEW statement.

NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!

Parameters:

sql - The SQL

See Also:

SQL