SqlConstants (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1.4.0)
E13403-05

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

oracle.javatools.parser.plsql.data
Interface SqlConstants

All Known Implementing Classes:: SqlAjndef, SqlColdef, SqlFrodef, SqlGbydef, SqlHqcdef, SqlLogdef, SqlOdmCost, SqlOdmdef, SqlOdmModel, SqlOpndef, SqlOptdef, SqlOrddef, SqlQbcdef, SqlSeldef, SqlStrdef, SqlTypdef, SqlXmtdef

public interface SqlConstants

A collection of all constants for the sql parser that don't get to fit into their own files. All constant names have been taken verbatim from rdbms. Associated comments have also been taken verbatim. I've added my own comments where appropriate, mostly in the form of "not implemented yet".

Field Summary
`static byte`	`OPNTATTR` ADT attribute (not implemented yet)
`static byte`	`OPNTCOL` database variable
`static byte`	`OPNTGBY` GROUP BY
`static byte`	`OPNTLAZ` lazy-evaluated operand (not implemented yet)
`static byte`	`OPNTLOG` Logdef (internal use)
`static byte`	`OPNTODM` Oracle Data Mining
`static byte`	`OPNTOPT` operator
`static byte`	`OPNTPLS` plsql function name operand (Treat OPNTPLS like OPNTOPT.
`static byte`	`OPNTQBP` query block pointer
`static byte`	`OPNTSEL` Selext list item
`static byte`	`OPNTSTR` string
`static byte`	`OPNTSYS` system variable (not implemented yet)
`static byte`	`OPNTTYP` Data Type
`static byte`	`QBCNALL` ALL subquery
`static byte`	`QBCNANY` ANY subquery
`static byte`	`QBCNCOLL` form-a-COLLection subquery
`static byte`	`QBCNEXISTS` EXISTS subquery
`static byte`	`QBCNFORSPCELL` Spreadsheet FOR cell index subquery
`static byte`	`QBCNLEVEL1` top-level query block or view
`static byte`	`QBCNNOTEXISTS` NOT EXISTS subquery
`static byte`	`QBCNSINGLE` single-row subquery
`static byte`	`QBCNSSQ` select-list subquery
`static byte`	`STRTANY` ANY
`static byte`	`STRTBIND` bind variable
`static byte`	`STRTCBR` CONNECT_BY_ROOT (not implemented yet)
`static byte`	`STRTCIOUT` str corresponds to output of a collection iterator (not implemented yet)
`static byte`	`STRTCONS` constant
`static byte`	`STRTCORR` correlation variable (not implemented yet)
`static byte`	`STRTCTS` CURRENT_TIMESTAMP
`static byte`	`STRTDATE` SYSDATE
`static byte`	`STRTDBTZ` DBTIMEZONE
`static byte`	`STRTDFT` column DeFaulT value
`static byte`	`STRTFMT` format string (lnxnf) (not implemented yet)
`static byte`	`STRTINL` str corresponds to an in-list (not implemented yet)
`static byte`	`STRTISCYL` CONNECT_BY_ISCYCLE
`static byte`	`STRTITNK` IOT Non-key
`static byte`	`STRTITRT` ITERATION_NUMBER
`static byte`	`STRTLEAF` CONNECT_BY_ISLEAF
`static byte`	`STRTLEVL` LEVEL
`static byte`	`STRTMAXV` MAXVALUE of a partition key (not implemented yet)
`static byte`	`STRTMQHBC` mixed hash & broadcast table queue control column (not implemented yet)
`static byte`	`STRTNULL` NULL
`static byte`	`STRTPRIO` PRIOR field (not implemented yet)
`static byte`	`STRTRNUM` ROWNUM
`static byte`	`STRTSETR` set result (not implemented yet)
`static byte`	`STRTSTS` SYSTIMESTAMP
`static byte`	`STRTSYST` system (internal use) (not implemented yet)
`static byte`	`STRTTQC_OBSOLETE` parallel Table Queue Column (not implemented yet)
`static byte`	`STRTTRG` trigger return variable (not implemented yet)
`static byte`	`STRTTVNM` Table/View Name
`static byte`	`STRTUID` UID
`static byte`	`STRTUSER` USER
`static byte`	`STRTVAR` str as a variable of another operand (not implemented yet)
`static byte`	`STRTVARC` variable column (not implemented yet)

Field Detail

OPNTCOL

static final byte OPNTCOL

database variable

See Also:: Constant Field Values

OPNTOPT

static final byte OPNTOPT

operator

See Also:: Constant Field Values

OPNTSTR

static final byte OPNTSTR

string

See Also:: Constant Field Values

OPNTSYS

static final byte OPNTSYS

system variable (not implemented yet)

See Also:: Constant Field Values

OPNTQBP

static final byte OPNTQBP

query block pointer

See Also:: Constant Field Values

OPNTLAZ

static final byte OPNTLAZ

lazy-evaluated operand (not implemented yet)

See Also:: Constant Field Values

OPNTPLS

static final byte OPNTPLS

plsql function name operand (Treat OPNTPLS like OPNTOPT. "a.b()" may only be an OPNTPLS. "a()" will be OPNTOPT if it matches a built-in SQL function; otherwise it will be an OPNTPLS.)