Skip navigation links

oracle.javatools.parser.plsql.syntax
Class SqlDriver

java.lang.Object
oracle.javatools.parser.plsql.syntax.SqlDriver

All Implemented Interfaces:

PtnodConstants, SqlOperators, SqlKeywords, SqlTokens, PtnodInternals

public class SqlDriver

extends java.lang.Object

All right! Here's the top of the sql stack.

Nested Class Summary

protected static class

BaseSqlLayer.Context

Field Summary

protected int	ctxoct Variable taken from common SQL parser state.
protected SqlFrodef	curFrodef current table name in FROM clause
protected SqlOrddef[]	curOrddef current ORDER BY clause
protected int	curToken The current lexer token.
protected int	errorCount The number of errors.
static int	FROFAJ this fro involved in anti join
static int	FROFALIAS alias is specified
static int	FROFALOK alias ok; flg to prstnm; NOT STORED in froflg
static int	FROFCL cluster allowed here
static int	FROFDFN K_MNT: default view name used
static int	FROFEXPV this fro resulted from a view expansion
static int	FROFFAKE fro is a fake object (IOT only)
static int	FROFFUNC
static int	FROFFXT fixed table
static int	FROFINTR frodef's view has instead-of trigger
static int	FROFKPT this is a key-preserved table
static int	FROFLNGNM this fro's tni is a LoNG NaMe
static int	FROFMP manual partition, pass 1
static int	FROFNDEP place no dependency on this one
static int	FROFNLAG Null-augment this table
static int	FROFNSTOK Nested table's Storage Table access OK
static int	FROFNTBC nested table column
static int	FROFODN Owner.Name was specified in original sql
static int	FROFOJ this fro involved in outer join
static int	FROFPPK if set, remote function name is of the format [<fronuser>.][<fronobject>.]<*froncoln>@fronnode if not set , then it is of the format [<fronuser>.]<fronobject>@fronnode
static int	FROFPRC procedure, function, package, or sequence allowed here
static int	FROFPXNM Partition eXtended NaMe frodef was created to represent an argument passed to a function - this frodef must be hung off qbcfncfr
static int	FROFRDO table is from a read only
static int	FROFRM remote table/view allowed here
static int	FROFSEQ marks frodef as a sequence frodef
static int	FROFSUBQ subquery in from clause
static int	FROFSWP swap sides of join
static int	FROFSYN original reference was to a synonym
static int	FROFTA table allowed here
static int	FROFTBSQ TABLE (subquery)
static int	FROFTBX TABLE expression
static int	FROFTHE backward compatibility
static int	FROFUNUSED UNUSED -- used to be TQ fro
static int	FROFVE view allowed here
protected int	handlerDepth The exception handler depth.
static int	INPUT_AEX Parse as a Arithmetic expression.
static int	INPUT_BEX Parse as a boolean expression.
static int	INPUT_CMD Parse as a SQL command.
static int	INPUT_SEX Parse as a SELECT list expression
static int	KOKB_EXTYP_CARDNL Cardinality function exp.
static int	KOKB_EXTYP_CAST CAST(expression AS nt_type)
static int	KOKB_EXTYP_CURSOR CURSOR (subquery)
static int	KOKB_EXTYP_FUNC function (not a table expression)
static int	KOKB_EXTYP_MSET MULTISET(subquery)
static int	KOKB_EXTYP_NOTTBL not a table expression
static int	KOKB_EXTYP_NTCIMG nested table column image
static int	KOKB_EXTYP_SUBQYCOLL collection subquery
static int	KOKB_EXTYP_SUBQYTHE the subquery
static int	KOKB_EXTYP_TBSQ TABLE (subquery), also THE (subquery)
protected int	lastCheckpoint The last checkpoint.
protected int	lastEndOffset The end offset of the previous token.
protected int	lastErrorOffset The offset of the last error
protected oracle.javatools.parser.plsql.syntax.BaseSqlLexer	lexer The associated PlsqlLexer.
static int	OCT_OBSOLETE former update indexes
static int	OCTACL alter cluster
static int	OCTADB alter database
static int	OCTADG alter disk group
static int	OCTADM alter dimension
static int	OCTAEP alter encryption profile
static int	OCTAFN alter function
static int	OCTAIT reserver for alter indextype
static int	OCTAIX alter index
static int	OCTAJV alter java
static int	OCTALB alter library
static int	OCTANC analyze cluster
static int	OCTANI analyze index
static int	OCTANT analyze table
static int	OCTAOP alter operator
static int	OCTAPB alter package body
static int	OCTAPF alter profile
static int	OCTAPK alter package
static int	OCTAPR alter procedure
static int	OCTARC alter resource cost
static int	OCTARO alter role
static int	OCTARS alter rollback segment
static int	OCTASE alter session
static int	OCTASL alter snapshot log
static int	OCTASM alter summary
static int	OCTASN alter snapshot
static int	OCTASO alter outline
static int	OCTASQ alter sequence
static int	OCTAST associate statistics
static int	OCTASY alter system switch log
static int	OCTASYN alter synonym
static int	OCTATB alter table
static int	OCTATG alter trigger
static int	OCTATR Alter tracing
static int	OCTATS alter tablespace
static int	OCTATY alter type
static int	OCTAUD audit
static int	OCTAUR alter user
static int	OCTAVW alter view
static int	OCTAYB alter type body
static int	OCTCAL call method
static int	OCTCBM create bitmapfile
static int	OCTCCF create control file
static int	OCTCCL create cluster
static int	OCTCCT create context
static int	OCTCDB create database
static int	OCTCDG create disk group
static int	OCTCDM create dimension
static int	OCTCDR create directory
static int	OCTCED create database link
static int	OCTCEP create encryption profile
static int	OCTCFN create function
static int	OCTCIT create indextype
static int	OCTCIX create index
static int	OCTCJV create java
static int	OCTCLB create library
static int	OCTCMT comment
static int	OCTCOP create opertaor
static int	OCTCPB create package body
static int	OCTCPF create profile
static int	OCTCPK create package
static int	OCTCPR create procedure
static int	OCTCPS create pfile from spfile
static int	OCTCPW change password
static int	OCTCRO create role
static int	OCTCRS create rollback segment
static int	OCTCSC create schema
static int	OCTCSL create snapshot log
static int	OCTCSM create summary
static int	OCTCSN create snapshot
static int	OCTCSO create outline
static int	OCTCSP create spfile from pfile
static int	OCTCSQ create sequence
static int	OCTCSY create synonym
static int	OCTCTB create table
static int	OCTCTG create trigger
static int	OCTCTS create tablespace
static int	OCTCTY create type
static int	OCTCUS create user
static int	OCTCVW create view
static int	OCTCWK commit
static int	OCTCYB create type body
static int	OCTDBM drop bitmapfile
static int	OCTDCL drop cluster
static int	OCTDCT drop context
static int	OCTDDB drop database
static int	OCTDDG drop disk group
static int	OCTDDM drop dimension
static int	OCTDDR drop directory
static int	OCTDED drop database link
static int	OCTDEL delete
static int	OCTDEP drop encryption profile
static int	OCTDFN drop function
static int	OCTDIT drop indextype
static int	OCTDIX drop index
static int	OCTDJV drop java
static int	OCTDLB drop library
static int	OCTDOP drop operator
static int	OCTDPB drop package body
static int	OCTDPF drop profile
static int	OCTDPK drop package
static int	OCTDPR drop procedure
static int	OCTDRO drop role
static int	OCTDRS drop rollback segment
static int	OCTDSL drop snapshot log
static int	OCTDSM drop summary
static int	OCTDSN drop snapshot
static int	OCTDSO drop outline
static int	OCTDSQ drop sequence
static int	OCTDST disassociate statistics
static int	OCTDSY drop synonym
static int	OCTDTB drop table
static int	OCTDTG drop trigger
static int	OCTDTS drop tablespace
static int	OCTDTY drop type
static int	OCTDUS drop user
static int	OCTDVW drop view
static int	OCTDYB drop type body
static int	OCTFBD flashback database
static int	OCTFBT flashback table
static int	OCTGRA grant
static int	OCTINS insert
static int	OCTLTB lock table
static int	OCTNOA noaudit
static int	OCTNOP no operation
static int	OCTPDB purge dba recyclebin
static int	OCTPIX purge index
static int	OCTPLS pl/sql execute
static int	OCTPRB purge user recyclebin
static int	OCTPTB purge table
static int	OCTPTS purge tablespace
static int	OCTREV revoke
static int	OCTRNM rename
static int	OCTROL rollback
static int	OCTSCO set constraints
static int	OCTSEL select
static int	OCTSER set role
static int	OCTSET set transaction
static int	OCTSPT savepoint
static int	OCTTCL truncate cluster
static int	OCTTTB truncate table
static int	OCTUDP undrop object
static int	OCTUJI update join index
static int	OCTUPD update
static int	OCTUPS upsert
static int	OCTVIX validate index
static int	OCTXPL explain
static short[]	OPT_comps
static byte[]	OPT_opns
protected int	prxopc operand count
protected SqlOpndef[]	prxops pointer to operand stack
static int	PTERR_ALTER_ATTR_MODIFY
static int	PTERR_ALTER_TYPE
static int	PTERR_base Base value for PTERR_* constants.
static int	PTERR_EXPECTING_IDENTIFIER
static int	PTERR_EXPECTING_N
static int	PTERR_EXPECTING_STRING
static int	PTERR_INTERNAL_ERROR
static int	PTERR_INVALID_INTERVAL
static int	PTERR_INVALID_PREDICATE
static int	PTERR_INVALID_TYPE_DEF
static int	PTERR_NOT_IMPLEMENTED_YET
static int	PTERR_PARAMETER_STYLE
static int	PTERR_PARTITION
static int	PTERR_SQLJ_USING
static int	PTERR_UNEXPECTED_TOKEN
static int	QCERR_EXPECTING_IDENTIFIER
static int	QCERR_INVALID_CASE
static int	QCERR_INVALID_DBNM
static int	QCERR_INVALID_EXPRESSION
static int	QCERR_INVALID_HEURISTIC
static int	QCERR_INVALID_INTERVAL
static int	QCERR_INVALID_JOIN
static int	QCERR_INVALID_LOCK_TABLE
static int	QCERR_INVALID_PREDICATE
static int	QCERR_INVALID_USING
static int	QCERR_LISTSIZE_MISMATCH
static int	QCERR_MISSING_EXPRESSION
static int	QCERR_NO_ALIAS
static int	QCERR_NO_CUBE_ROLLUP
static int	QCERR_NO_INLINE_VIEW
static int	QCERR_NO_LIST_OPERANDS
static int	QCERR_NO_SAMPLE
static int	QCERR_RELOP_NEED_ANYALL
static int	QCERR_SUBQUERY_REQUIRED
static int	QCERR_TOO_MANY_OPERANDS
static int	QCERR_UNEXPECTED_EOS
static int	QCERR_UNKNOWN
static int	QCERR_UNRECOGNISED_PIVOT_CLAUSE
static int	QCERR_UNRECOGNISED_UNPIVOT_CLAUSE
protected static int	QCPICNMF_FOUNDNEW found NEW before function name
protected static int	QCPICNMF_INSLIST columns part of insert list
protected static int	QCPICNMF_OUTERJOIN outer-join OK
protected static int	QCPICNMF_ROWID ROWID allowed here
protected static int	QCPICNMF_UTAB <user> DOT notation ok
protected static int	QCPIILB_BIND found an internal bind (was originally a literal)
protected static int	QCPIILB_LITERAL found a real literal
protected static int	QCPIILB_NONE found neither
protected static oracle.javatools.resource.BundleHelper	resources
protected PtnodRoot	root The root node of the parse tree.
protected AST[]	stack The AST stack.
protected int	stackHeight The depth of the AST stack.
protected AST	stackTop The top of the AST stack.
protected ReadTextBuffer	textBuffer The input text buffer.

Fields inherited from interface oracle.javatools.parser.plsql.SqlTokens

OP_AMPERSAND, OP_ARROW, OP_ASSIGN, OP_ATSIGN, OP_base, OP_CAT, OP_COLON, OP_COMMA, OP_DBLDOT, OP_DOT, OP_ELLIPSIS, OP_EQUAL, OP_EXP, OP_GREATER, OP_GTEQL, OP_L_LBL, OP_LBRKT, OP_LESS, OP_LPAREN, OP_LTEQ, OP_max, OP_MINUS, OP_NOTEQL1, OP_NOTEQL2, OP_NOTEQL3, OP_NOTEQL4, OP_OR, OP_OUTERJOIN, OP_PERCENT, OP_PLUS, OP_R_LBL, OP_RBRKT, OP_RPAREN, OP_SEMICLN, OP_SHRIEK, OP_SLASH, OP_STAR, OP_words, TK_BIND_VAR, TK_EOS, TK_IDENTIFIER, TK_invalid, TK_INVALID, TK_MULTI_COMMENT, TK_N, TK_QUOTED_IDENTIFIER, TK_SINGLE_COMMENT, TK_STRING

Fields inherited from interface oracle.javatools.parser.plsql.SqlKeywords

DW_values, DW_words, KW_A, KW_ABORT, KW_ACCESS, KW_ACCESSED, KW_ACCOUNT, KW_ACTIVATE, KW_ADD, KW_ADMIN, KW_ADMINISTER, KW_ADMINISTRATOR, KW_ADVISE, KW_ADVISOR, KW_AFTER, KW_ALGORITHM, KW_ALIAS, KW_ALL, KW_ALL_ROWS, KW_ALLOCATE, KW_ALLOW, KW_ALTER, KW_ALWAYS, KW_ANALYZE, KW_ANCILLARY, KW_AND, KW_AND_EQUAL, KW_ANTIJOIN, KW_ANY, KW_APPEND, KW_APPLY, KW_ARCHIVE, KW_ARCHIVELOG, KW_ARRAY, KW_AS, KW_ASC, KW_ASSOCIATE, KW_AT, KW_ATTRIBUTE, KW_ATTRIBUTES, KW_AUDIT, KW_AUTHENTICATED, KW_AUTHENTICATION, KW_AUTHID, KW_AUTHORIZATION, KW_AUTO, KW_AUTOALLOCATE, KW_AUTOEXTEND, KW_AUTOMATIC, KW_AVAILABILITY, KW_BACKUP, KW_base, KW_BECOME, KW_BEFORE, KW_BEGIN, KW_BEHALF, KW_BETWEEN, KW_BFILE, KW_BIGFILE, KW_BINARY_DOUBLE, KW_BINARY_DOUBLE_INFINITY, KW_BINARY_DOUBLE_NAN, KW_BINARY_FLOAT, KW_BINARY_FLOAT_INFINITY, KW_BINARY_FLOAT_NAN, KW_BINDING, KW_BITMAP, KW_BITS, KW_BLOB, KW_BLOCK, KW_BLOCKS, KW_BLOCKSIZE, KW_BLOCKW_RANGE, KW_BODY, KW_BOTH, KW_BOUND, KW_BROADCAST, KW_BUFFER, KW_BUFFER_CACHE, KW_BUFFER_POOL, KW_BUILD, KW_BULK, KW_BY, KW_BYPASS_RECURSIVE_CHECK, KW_BYPASS_UJVC, KW_BYTE, KW_CACHE, KW_CACHE_CB, KW_CACHE_INSTANCES, KW_CACHE_TEMP_TABLE, KW_CALL, KW_CANCEL, KW_CARDINALITY, KW_CASCADE, KW_CASE, KW_CAST, KW_CATEGORY, KW_CERTIFICATE, KW_CFILE, KW_CHAINED, KW_CHANGE, KW_CHAR, KW_CHAR_CS, KW_CHECK, KW_CHECKPOINT, KW_CHILD, KW_CHOOSE, KW_CHUNK, KW_CIV_GB, KW_CLASS, KW_CLEAR, KW_CLOB, KW_CLONE, KW_CLOSE, KW_CLOSE_CACHED_OPEN_CURSORS, KW_CLUSTER, KW_CLUSTERING_FACTOR, KW_COALESCE, KW_COARSE, KW_COLLECT, KW_COLLECTIONS_GET_REFS, KW_COLUMN, KW_COLUMN_STATS, KW_COLUMN_VALUE, KW_COLUMNS, KW_COMMENT, KW_COMMIT, KW_COMMITTED, KW_COMPACT, KW_COMPATIBILITY, KW_COMPILE, KW_COMPLETE, KW_COMPOSITE_LIMIT, KW_COMPRESS, KW_COMPUTE, KW_CONFORMING, KW_CONNECT, KW_CONNECT_BY_ISCYCLE, KW_CONNECT_BY_ISLEAF, KW_CONNECT_BY_ROOT, KW_CONNECT_TIME, KW_CONSIDER, KW_CONSISTENT, KW_CONSTRAINT, KW_CONTAINER, KW_CONTENT, KW_CONTENTS, KW_CONTEXT, KW_CONTINUE, KW_CONTROLFILE, KW_CONVERT, KW_CORRUPTION, KW_COST, KW_CPU_COSTING, KW_CPU_PER_CALL, KW_CPU_PER_SESSION, KW_CREATE, KW_CREATE_STORED_OUTLINES, KW_CROSS, KW_CUBE, KW_CUBE_GB, KW_CURRENT, KW_CURRENT_DATE, KW_CURRENT_SCHEMA, KW_CURRENT_TIME, KW_CURRENT_TIMESTAMP, KW_CURRENT_USER, KW_CURSOR, KW_CURSOR_SHARING_EXACT, KW_CURSOR_SPECIFIC_SEGMENT, KW_CYCLE, KW_DANGLING, KW_DATA, KW_DATABASE, KW_DATAFILE, KW_DATAFILES, KW_DATAOBJNO, KW_DATE, KW_DATE_MODE, KW_DAY, KW_DBA, KW_DBA_RECYCLEBIN, KW_DBTIMEZONE, KW_DDL, KW_DEALLOCATE, KW_DEBUG, KW_DEC, KW_DECLARE, KW_DECREMENT, KW_DEFAULT, KW_DEFERRABLE, KW_DEFERRED, KW_DEFINED, KW_DEFINER, KW_DEGREE, KW_DELAY, KW_DELETE, KW_DEMAND, KW_DENSE_RANK, KW_DEREF, KW_DEREF_NO_REWRITE, KW_DESC, KW_DETACHED, KW_DETERMINES, KW_DICTIONARY, KW_DIMENSION, KW_DIRECTORY, KW_DISABLE, KW_DISASSOCIATE, KW_DISCONNECT, KW_DISK, KW_DISKGROUP, KW_DISKS, KW_DISMOUNT, KW_DISTINCT, KW_DISTINGUISHED, KW_DISTRIBUTED, KW_DML, KW_DML_UPDATE, KW_DOCUMENT, KW_DOMAIN_INDEX_NO_SORT, KW_DOMAIN_INDEX_SORT, KW_DOUBLE, KW_DOWNGRADE, KW_DRIVING_SITE, KW_DROP, KW_DUMP, KW_DYNAMIC, KW_DYNAMIC_SAMPLING, KW_DYNAMIC_SAMPLING_EST_CDN, KW_EACH, KW_ELEMENT, KW_ELSE, KW_EMPTY, KW_ENABLE, KW_ENCRYPTED, KW_ENCRYPTION, KW_END, KW_ENFORCE, KW_ENFORCED, KW_ENTRY, KW_ERROR, KW_ERROR_ON_OVERLAP_TIME, KW_ESCAPE, KW_ESTIMATE, KW_EVENTS, KW_EXCEPT, KW_EXCEPTIONS, KW_EXCHANGE, KW_EXCLUDING, KW_EXCLUSIVE, KW_EXECUTE, KW_EXEMPT, KW_EXISTS, KW_EXPAND_GSET_TO_UNION, KW_EXPIRE, KW_EXPLAIN, KW_EXPLOSION, KW_EXPORT, KW_EXPR_CORR_CHECK, KW_EXTEND, KW_EXTENDS, KW_EXTENT, KW_EXTENTS, KW_EXTERNAL, KW_EXTERNALLY, KW_EXTRACT, KW_FACT, KW_FAILED, KW_FAILED_LOGIN_ATTEMPTS, KW_FAILGROUP, KW_FALSE, KW_FAST, KW_FBTSCAN, KW_FIC_CIV, KW_FIC_PIV, KW_FILE, KW_FILTER, KW_FINAL, KW_FINE, KW_FINISH, KW_first, KW_FIRST, KW_FIRST_ROWS, KW_FLAGGER, KW_FLASHBACK, KW_FLOAT, KW_FLOB, KW_FLUSH, KW_FOLLOWING, KW_FOR, KW_FORCE, KW_FORCE_XML_QRY_REW, KW_FOREIGN, KW_FREELIST, KW_FREELISTS, KW_FREEPOOLS, KW_FRESH, KW_FROM, KW_FULL, KW_FUNCTION, KW_FUNCTIONS, KW_GATHER_PLAN_STATISTICS, KW_GBY_CONC_ROLLUP, KW_GENERATED, KW_GLOBAL, KW_GLOBAL_NAME, KW_GLOBAL_TOPIC_ENABLED, KW_GLOBALLY, KW_GRANT, KW_GROUP, KW_GROUP_BY, KW_GROUPING, KW_GROUPS, KW_GUARANTEE, KW_GUARANTEED, KW_GUARD, KW_HASH, KW_HASH_AJ, KW_HASH_SJ, KW_HASHKEYS, KW_HAVING, KW_HEADER, KW_HEAP, KW_HIERARCHY, KW_HIGH, KW_HINTSET_BEGIN, KW_HINTSET_END, KW_HOUR, KW_HWM_BROKERED, KW_ID, KW_IDENTIFIED, KW_IDENTIFIER, KW_IDENTITY, KW_IDGENERATORS, KW_IDLE_TIME, KW_IF, KW_IGNORE, KW_IGNORE_ON_CLAUSE, KW_IGNORE_OPTIM_EMBEDDED_HINTS, KW_IGNORE_WHERE_CLAUSE, KW_IMMEDIATE, KW_IMPORT, KW_IN, KW_IN_MEMORY_METADATA, KW_INCLUDING, KW_INCREMENT, KW_INCREMENTAL, KW_INDEX, KW_INDEX_ASC, KW_INDEX_COMBINE, KW_INDEX_DESC, KW_INDEX_FFS, KW_INDEX_FILTER, KW_INDEX_JOIN, KW_INDEX_RRS, KW_INDEX_SCAN, KW_INDEX_SKIP_SCAN, KW_INDEX_SS, KW_INDEX_SS_ASC, KW_INDEX_SS_DESC, KW_INDEX_STATS, KW_INDEXED, KW_INDEXES, KW_INDEXTYPE, KW_INDEXTYPES, KW_INDICATOR, KW_INFINITE, KW_INFORMATIONAL, KW_INITIAL, KW_INITIALIZED, KW_INITIALLY, KW_INITRANS, KW_INLINE, KW_INNER, KW_INSERT, KW_INSTANCE, KW_INSTANCES, KW_INSTANTIABLE, KW_INSTANTLY, KW_INSTEAD, KW_INT, KW_INTEGRITY, KW_INTERMEDIATE, KW_INTERNAL_CONVERT, KW_INTERNAL_USE, KW_INTERPRETED, KW_INTERSECT, KW_INTERVAL, KW_INTO, KW_INVALIDATE, KW_IS, KW_ISOLATION, KW_ISOLATION_LEVEL, KW_ITERATE, KW_ITERATION_NUMBER, KW_JAVA, KW_JOB, KW_JOIN, KW_KEEP, KW_KERBEROS, KW_KEY, KW_KEY_LENGTH, KW_KEYFILE, KW_KEYS, KW_KEYSIZE, KW_KILL, KW_last, KW_LAST, KW_LATERAL, KW_LAYER, KW_LDAP_REG_SYNC_INTERVAL, KW_LDAP_REGISTRATION, KW_LDAP_REGISTRATION_ENABLED, KW_LEADING, KW_LEFT, KW_LENGTH, KW_LESS, KW_LEVEL, KW_LEVELS, KW_LIBRARY, KW_LIKE, KW_LIKE_EXPAND, KW_LIKE2, KW_LIKE4, KW_LIKEC, KW_LIMIT, KW_LINK, KW_LIST, KW_LOB, KW_LOCAL, KW_LOCAL_INDEXES, KW_LOCALTIME, KW_LOCALTIMESTAMP, KW_LOCATION, KW_LOCATOR, KW_LOCK, KW_LOCKED, KW_LOG, KW_LOGFILE, KW_LOGGING, KW_LOGICAL, KW_LOGICAL_READS_PER_CALL, KW_LOGICAL_READS_PER_SESSION, KW_LOGOFF, KW_LOGON, KW_LONG, KW_MAIN, KW_MANAGE, KW_MANAGED, KW_MANAGEMENT, KW_MANUAL, KW_MAPPING, KW_MASTER, KW_MATCHED, KW_MATERIALIZE, KW_MATERIALIZED, KW_max, KW_MAX, KW_MAXDATAFILES, KW_MAXEXTENTS, KW_MAXIMIZE, KW_MAXINSTANCES, KW_MAXLOGFILES, KW_MAXLOGHISTORY, KW_MAXLOGMEMBERS, KW_MAXSIZE, KW_MAXTRANS, KW_MAXVALUE, KW_MEASURES, KW_MEMBER, KW_MEMORY, KW_MERGE, KW_MERGE_AJ, KW_MERGE_CONST_ON, KW_MERGE_SJ, KW_METHOD, KW_MIGRATE, KW_MIN, KW_MINEXTENTS, KW_MINIMIZE, KW_MINIMUM, KW_MINUS, KW_MINUTE, KW_MINVALUE, KW_MIRROR, KW_MLSLABEL, KW_MODE, KW_MODEL, KW_MODIFY, KW_MONITORING, KW_MONTH, KW_MOUNT, KW_MOVE, KW_MOVEMENT, KW_MULTISET, KW_MV_MERGE, KW_NAME, KW_NAMED, KW_NAN, KW_NATIONAL, KW_NATIVE, KW_NATURAL, KW_NAV, KW_NCHAR, KW_NCHAR_CS, KW_NCLOB, KW_NEEDED, KW_NESTED, KW_NESTED_TABLE_FAST_INSERT, KW_NESTED_TABLE_GET_REFS, KW_NESTED_TABLE_ID, KW_NESTED_TABLE_SET_SETID, KW_NETWORK, KW_NEVER, KW_NEW, KW_NEXT, KW_NL_AJ, KW_NL_SJ, KW_NLS_CALENDAR, KW_NLS_CHARACTERSET, KW_NLS_COMP, KW_NLS_CURRENCY, KW_NLS_DATE_FORMAT, KW_NLS_DATE_LANGUAGE, KW_NLS_ISO_CURRENCY, KW_NLS_LANG, KW_NLS_LANGUAGE, KW_NLS_LENGTH_SEMANTICS, KW_NLS_NCHAR_CONV_EXCP, KW_NLS_NUMERIC_CHARACTERS, KW_NLS_SORT, KW_NLS_SPECIAL_CHARS, KW_NLS_TERRITORY, KW_NO, KW_NO_ACCESS, KW_NO_BASETABLE_MULTIMV_REWRITE, KW_NO_BUFFER, KW_NO_CPU_COSTING, KW_NO_EXPAND, KW_NO_EXPAND_GSET_TO_UNION, KW_NO_FACT, KW_NO_FILTERING, KW_NO_INDEX, KW_NO_INDEX_FFS, KW_NO_INDEX_SS, KW_NO_MERGE, KW_NO_MONITORING, KW_NO_MULTIMV_REWRITE, KW_NO_ORDER_ROLLUPS, KW_NO_PARALLEL, KW_NO_PARALLEL_INDEX, KW_NO_PRUNE_GSETS, KW_NO_PUSH_PRED, KW_NO_PUSH_SUBQ, KW_NO_QKN_BUFF, KW_NO_QUERY_TRANSFORMATION, KW_NO_REF_CASCADE, KW_NO_REWRITE, KW_NO_SEMIJOIN, KW_NO_SET_TO_JOIN, KW_NO_SPREAD_PUSH_REFPRED, KW_NO_STAR_TRANSFORMATION, KW_NO_STATS_GSETS, KW_NO_SWAP_JOIN_INPUTS, KW_NO_TRIGGER, KW_NO_UNNEST, KW_NO_USE_HASH, KW_NO_USE_MERGE, KW_NO_USE_NL, KW_NO_XML_QRY_REW, KW_NOAPPEND, KW_NOARCHIVELOG, KW_NOAUDIT, KW_NOCACHE, KW_NOCOMPRESS, KW_NOCYCLE, KW_NODELAY, KW_NOFORCE, KW_NOGUARANTEE, KW_NOLOGGING, KW_NOMAPPING, KW_NOMAXVALUE, KW_NOMINIMIZE, KW_NOMINVALUE, KW_NOMONITORING, KW_NONE, KW_NOORDER, KW_NOOVERRIDE, KW_NOPARALLEL, KW_NORELY, KW_NOREPAIR, KW_NORESETLOGS, KW_NOREVERSE, KW_NORMAL, KW_NOROWDEPENDENCIES, KW_NOSEGMENT, KW_NOSORT, KW_NOSTRICT, KW_NOSWITCH, KW_NOT, KW_NOTHING, KW_NOVALIDATE, KW_NOWAIT, KW_NULL, KW_NULLS, KW_NUMBER, KW_NUMERIC, KW_NVARCHAR2, KW_OBJECT, KW_OBJNO, KW_OBJNO_REUSE, KW_OF, KW_OFF, KW_OFFLINE, KW_OID, KW_OIDINDEX, KW_OLD, KW_ON, KW_ONLINE, KW_ONLY, KW_OPAQUE, KW_OPAQUE_TRANSFORM, KW_OPAQUE_XCANONICAL, KW_OPCODE, KW_OPEN, KW_OPERATOR, KW_OPT_ESTIMATE, KW_OPTIMAL, KW_OPTIMIZER_FEATURES_ENABLE, KW_OPTIMIZER_GOAL, KW_OPTION, KW_OR, KW_OR_EXPAND, KW_ORA_ROWSCN, KW_ORDER, KW_ORDERED, KW_ORDERED_PREDICATES, KW_ORGANIZATION, KW_OUT_OF_LINE, KW_OUTER, KW_OUTLINE, KW_OVER, KW_OVERFLOW, KW_OVERFLOW_NOMOVE, KW_OVERLAPS, KW_OWN, KW_PACKAGE, KW_PACKAGES, KW_PARALLEL_INDEX, KW_PARAMETERS, KW_PARENT, KW_PARITY, KW_PARTIALLY, KW_PARTITION, KW_PARTITION_HASH, KW_PARTITION_LIST, KW_PARTITION_RANGE, KW_PARTITIONS, KW_PASSWORD, KW_PASSWORD_GRACE_TIME, KW_PASSWORD_LIFE_TIME, KW_PASSWORD_LOCKW_TIME, KW_PASSWORD_REUSE_MAX, KW_PASSWORD_REUSE_TIME, KW_PASSWORD_VERIFY_FUNCTION, KW_PCTFREE, KW_PCTINCREASE, KW_PCTTHRESHOLD, KW_PCTUSED, KW_PCTVERSION, KW_PERCENT, KW_PERFORMANCE, KW_PERMANENT, KW_PFILE, KW_PHYSICAL, KW_PIV_GB, KW_PIV_SSF, KW_PLAN, KW_PLSQL_CODE_TYPE, KW_PLSQL_DEBUG, KW_PLSQL_OPTIMIZE_LEVEL, KW_PLSQL_WARNINGS, KW_POLICY, KW_POST_TRANSACTION, KW_POWER, KW_PQ_DISTRIBUTE, KW_PQ_MAP, KW_PQ_NOMAP, KW_PREBUILT, KW_PRECEDING, KW_PRECISION, KW_PREPARE, KW_PRESENT, KW_PRESERVE, KW_PRIMARY, KW_PRIOR, KW_PRIVATE, KW_PRIVATE_SGA, KW_PRIVILEGES, KW_PROCEDURE, KW_PROFILE, KW_PROGRAM, KW_PROJECT, KW_PROTECTED, KW_PROTECTION, KW_PUBLIC, KW_PURGE, KW_PUSH_PRED, KW_PUSH_SUBQ, KW_PX_GRANULE, KW_QB_NAME, KW_QUERY, KW_QUERY_BLOCK, KW_QUEUE, KW_QUEUE_CURR, KW_QUEUE_ROWP, KW_QUIESCE, KW_QUOTA, KW_RANDOM, KW_RANGE, KW_RAPIDLY, KW_RAW, KW_RBA, KW_READ, KW_READS, KW_REAL, KW_REBALANCE, KW_REBUILD, KW_RECORDS_PER_BLOCK, KW_RECOVER, KW_RECOVERABLE, KW_RECOVERY, KW_RECYCLE, KW_RECYCLEBIN, KW_REDUCED, KW_REDUNDANCY, KW_REF, KW_REF_CASCADE_CURSOR, KW_REFERENCE, KW_REFERENCED, KW_REFERENCES, KW_REFRESH, KW_REGEXP_LIKE, KW_REGISTER, KW_REJECT, KW_REKEY, KW_RELATIONAL, KW_RELY, KW_REMOTE_MAPPED, KW_RENAME, KW_REPAIR, KW_REPLACE, KW_REQUIRED, KW_RESET, KW_RESETLOGS, KW_RESIZE, KW_RESOLVE, KW_RESOLVER, KW_RESOURCE, KW_RESTORE_AS_INTERVALS, KW_RESTRICT, KW_RESTRICT_ALL_REF_CONS, KW_RESTRICTED, KW_RESUMABLE, KW_RESUME, KW_RETENTION, KW_RETURN, KW_RETURNING, KW_REUSE, KW_REVERSE, KW_REVOKE, KW_REWRITE, KW_REWRITE_OR_ERROR, KW_RIGHT, KW_ROLE, KW_ROLLBACK, KW_ROLLUP, KW_ROW, KW_ROW_LENGTH, KW_ROWDEPENDENCIES, KW_ROWID, KW_ROWNUM, KW_ROWS, KW_RULE, KW_RULES, KW_SAMPLE, KW_SAVE_AS_INTERVALS, KW_SAVEPOINT, KW_SCALE, KW_SCALE_ROWS, KW_SCAN, KW_SCAN_INSTANCES, KW_SCHEDULER, KW_SCHEMA, KW_SCN, KW_SCN_ASCENDING, KW_SCOPE, KW_SD_ALL, KW_SD_INHIBIT, KW_SD_SHOW, KW_SECOND, KW_SECURITY, KW_SEED, KW_SEG_BLOCK, KW_SEG_FILE, KW_SEGMENT, KW_SELECT, KW_SELECTIVITY, KW_SEMIJOIN, KW_SEMIJOIN_DRIVER, KW_SEQUENCE, KW_SEQUENCED, KW_SEQUENTIAL, KW_SERIALIZABLE, KW_SERVERERROR, KW_SESSION, KW_SESSION_CACHED_CURSORS, KW_SESSIONS_PER_USER, KW_SESSIONTIMEZONE, KW_SESSIONTZNAME, KW_SET, KW_SET_TO_JOIN, KW_SETS, KW_SETTINGS, KW_SEVERE, KW_SHARE, KW_SHARED, KW_SHARED_POOL, KW_SHRINK, KW_SHUTDOWN, KW_SIBLINGS, KW_SID, KW_SIMPLE, KW_SINGLE, KW_SINGLETASK, KW_SIZE, KW_SKIP, KW_SKIP_EXT_OPTIMIZER, KW_SKIP_UNQ_UNUSABLE_IDX, KW_SKIP_UNUSABLE_INDEXES, KW_SMALLFILE, KW_SNAPSHOT, KW_SOME, KW_SORT, KW_SOURCE, KW_SPACE, KW_SPECIFICATION, KW_SPFILE, KW_SPLIT, KW_SPREAD_DONTVERIFY_UNIQUENESS, KW_SPREAD_MIN_ANALYSIS, KW_SPREAD_NO_ANALYSIS, KW_SPREAD_PUSH_REFPRED, KW_SPREADSHEET, KW_SPREADSHEET_PBY, KW_SQL, KW_SQL_TRACE, KW_SQLLDR, KW_STANDBY, KW_STAR_HINT, KW_STAR_TRANSFORMATION, KW_START, KW_STARTUP, KW_STATEMENT_ID, KW_STATIC, KW_STATISTICS, KW_STOP, KW_STORAGE, KW_STORE, KW_STREAMS, KW_STRICT, KW_STRIP, KW_STRUCTURE, KW_SUBMULTISET, KW_SUBPARTITION, KW_SUBPARTITION_REL, KW_SUBPARTITIONS, KW_SUBSTITUTABLE, KW_SUCCESSFUL, KW_SUMMARY, KW_SUPPLEMENTAL, KW_SUSPEND, KW_SWAP_JOIN_INPUTS, KW_SWITCH, KW_SWITCHOVER, KW_SYNONYM, KW_SYS_DL_CURSOR, KW_SYS_FBT_INSDEL, KW_SYS_OP_BITVEC, KW_SYS_OP_CAST, KW_SYS_OP_COL_PRESENT, KW_SYS_OP_ENFORCE_NOT_NULL, KW_SYS_OP_MINE_VALUE, KW_SYS_OP_NOEXPAND, KW_SYS_OP_NTCIMG, KW_SYS_PARALLEL_TXN, KW_SYS_RID_ORDER, KW_SYSAUX, KW_SYSDATE, KW_SYSDBA, KW_SYSOPER, KW_SYSTEM, KW_SYSTIMESTAMP, KW_TABLE, KW_TABLE_STATS, KW_TABLES, KW_TABLESPACE, KW_TABLESPACE_NUMBER, KW_TABNO, KW_TEMPFILE, KW_TEMPLATE, KW_TEMPORARY, KW_TEST, KW_THAN, KW_THE, KW_THEN, KW_THREAD, KW_THROUGH, KW_TIME, KW_TIME_ZONE, KW_TIMEOUT, KW_TIMESTAMP, KW_TIMEZONE_ABBR, KW_TIMEZONE_HOUR, KW_TIMEZONE_MINUTE, KW_TIMEZONE_REGION, KW_TIV_GB, KW_TIV_SSF, KW_TO, KW_TOPLEVEL, KW_TRACE, KW_TRACING, KW_TRACKING, KW_TRAILING, KW_TRANSACTION, KW_TRANSITIONAL, KW_TREAT, KW_TRIGGER, KW_TRIGGERS, KW_TRUE, KW_TRUNCATE, KW_TRUSTED, KW_TUNING, KW_TX, KW_TYPE, KW_TYPES, KW_TZ_OFFSET, KW_UBA, KW_UID, KW_UNARCHIVED, KW_UNBOUND, KW_UNBOUNDED, KW_UNDER, KW_UNDO, KW_UNDROP, KW_UNIFORM, KW_UNION, KW_UNIQUE, KW_UNLIMITED, KW_UNLOCK, KW_UNNEST, KW_UNPACKED, KW_UNPROTECTED, KW_UNQUIESCE, KW_UNRECOVERABLE, KW_UNTIL, KW_UNUSABLE, KW_UNUSED, KW_UPD_INDEXES, KW_UPD_JOININDEX, KW_UPDATABLE, KW_UPDATE, KW_UPDATED, KW_UPGRADE, KW_UPSERT, KW_UROWID, KW_USAGE, KW_USE, KW_USE_ANTI, KW_USE_CONCAT, KW_USE_HASH, KW_USE_MERGE, KW_USE_NL, KW_USE_NL_WITH_INDEX, KW_USE_PRIVATE_OUTLINES, KW_USE_SEMI, KW_USE_STORED_OUTLINES, KW_USE_TTT_FOR_GSETS, KW_USE_WEAKW_NAME_RESL, KW_USER, KW_USER_DEFINED, KW_USER_RECYCLEBIN, KW_USING, KW_VALIDATE, KW_VALIDATION, KW_VALUE, KW_VALUES, KW_VARCHAR, KW_VARCHAR2, KW_VARRAY, KW_VARYING, KW_VECTOR_READ, KW_VECTOR_READ_TRACE, KW_VERSION, KW_VERSIONS, KW_VIEW, KW_WAIT, KW_WELLFORMED, KW_WHEN, KW_WHENEVER, KW_WHERE, KW_WHITESPACE, KW_WITH, KW_WITHIN, KW_WITHOUT, KW_words, KW_WORK, KW_WRITE, KW_X_DYN_PRUNE, KW_XID, KW_XMLATTRIBUTES, KW_XMLCOLATTVAL, KW_XMLELEMENT, KW_XMLFOREST, KW_XMLPARSE, KW_XMLSCHEMA, KW_XMLTYPE, KW_YEAR, KW_ZONE, RW_ALL, RW_ALTER, RW_AND, RW_ANY, RW_AS, RW_ASC, RW_BETWEEN, RW_BY, RW_CHECK, RW_CLUSTER, RW_COMPRESS, RW_CONNECT, RW_CREATE, RW_DATE, RW_DEFAULT, RW_DELETE, RW_DESC, RW_DISTINCT, RW_DROP, RW_ELSE, RW_EXCLUSIVE, RW_EXISTS, RW_first, RW_FLOAT, RW_FOR, RW_FROM, RW_GRANT, RW_GROUP, RW_HAVING, RW_IDENTIFIED, RW_IN, RW_INDEX, RW_INSERT, RW_INTERSECT, RW_INTO, RW_IS, RW_last, RW_LIKE, RW_LOCK, RW_LONG, RW_MINUS, RW_MODE, RW_NOCOMPRESS, RW_NOT, RW_NOWAIT, RW_NULL, RW_NUMBER, RW_OF, RW_ON, RW_OPTION, RW_OR, RW_ORDER, RW_PCTFREE, RW_PRIOR, RW_PUBLIC, RW_RAW, RW_RENAME, RW_RESOURCE, RW_REVOKE, RW_SELECT, RW_SET, RW_SHARE, RW_SIZE, RW_START, RW_SYNONYM, RW_TABLE, RW_THEN, RW_TO, RW_TRIGGER, RW_UNION, RW_UNIQUE, RW_UPDATE, RW_VALUES, RW_VARCHAR, RW_VARCHAR2, RW_VIEW, RW_WHERE, RW_WITH, SW_ACCESS, SW_ADD, SW_AUDIT, SW_COLUMN, SW_COMMENT, SW_CURRENT, SW_FILE, SW_first, SW_IMMEDIATE, SW_INCREMENT, SW_INITIAL, SW_last, SW_LEVEL, SW_MAXEXTENTS, SW_MLSLABEL, SW_MODIFY, SW_NOAUDIT, SW_OFFLINE, SW_ONLINE, SW_PRIVILEGES, SW_ROW, SW_ROWID, SW_ROWNUM, SW_ROWS, SW_SESSION, SW_SUCCESSFUL, SW_SYSDATE, SW_UID, SW_USER, SW_VALIDATE, SW_WHENEVER

Fields inherited from interface oracle.javatools.parser.plsql.data.SqlOperators

OPT_base, OPT_invalid, OPT_max, OPT_words, OPT112, OPT186, OPT188, OPT534, OPTACLCHK, OPTACN, OPTADJD, OPTADT2B, OPTAEQ, OPTAGE, OPTAGGOBY, OPTAGT, OPTALANYCONS, OPTALE, OPTALSCRVAL, OPTALT, OPTAND, OPTANE, OPTANOVAONE, OPTANOVAONED, OPTAPPXML, OPTASCNF, OPTASCS, OPTASN, OPTASNPT, OPTATG, OPTATN, OPTATOC, OPTATS, OPTATT, OPTAUD, OPTAWOG, OPTB2ADT, OPTB2N, OPTBETWEEN, OPTBF2RAW, OPTBFIL, OPTBLCST, OPTBLOB, OPTBLOBIMG, OPTBNPT, OPTBTEST, OPTBTR, OPTBTUR, OPTC2C, OPTC2IDS, OPTC2ITZ, OPTC2IYM, OPTC2OP, OPTC2ST, OPTC2STZ, OPTC2TM, OPTC2TMZ, OPTCARD, OPTCAST, OPTCAST2, OPTCAST3, OPTCCG, OPTCCN, OPTCDL, OPTCDN, OPTCDY, OPTCEG, OPTCELEM, OPTCFN, OPTCFX, OPTCHGTZ, OPTCIDN, OPTCIOUT, OPTCL2NCL, OPTCLCST, OPTCLOB, OPTCND, OPTCNF, OPTCNV, OPTCOERCE, OPTCOLES, OPTCOLLCONS, OPTCOMP, OPTCONS, OPTCORR, OPTCORRK, OPTCORRS, OPTCOS, OPTCOVARP, OPTCOVARS, OPTCPRESENT, OPTCPSE, OPTCROSSTAB, OPTCSCNV, OPTCSH, OPTCSID, OPTCSIV, OPTCSNAME, OPTCSR, OPTCTUR, OPTCTX, OPTCTZ, OPTCURRENT_ROW, OPTDAM, OPTDAN, OPTDAT2TS1, OPTDAT2TS2, OPTDBURIGEN, OPTDCAST, OPTDCC, OPTDDI, OPTDDJ, OPTDDS, OPTDDSUB, OPTDECOMP, OPTDECP, OPTDELXML, OPTDEREF, OPTDESC, OPTDESNF, OPTDESNL, OPTDFNR, OPTDFS, OPTDGRF, OPTDIADD, OPTDID, OPTDIF, OPTDIJ, OPTDIPR, OPTDIS, OPTDIST, OPTDISUB, OPTDJN, OPTDJS, OPTDLD, OPTDM, OPTDMCLUS, OPTDMCLUSP, OPTDMCLUSS, OPTDMFEAT, OPTDMFEATS, OPTDMFEATV, OPTDMPRED, OPTDMPREDC, OPTDMPREDD, OPTDMPREDP, OPTDMPREDS, OPTDND, OPTDNJ, OPTDOF, OPTDOMCMP, OPTDOT, OPTDPC, OPTDRA, OPTDRO, OPTDSC, OPTDSD, OPTDSI, OPTDSM, OPTDSN, OPTDSU, OPTDSY, OPTDTR, OPTDTZ, OPTEBLOB, OPTECLOB, OPTEQUALS_ANY, OPTEXP, OPTFCDEI, OPTFCDF, OPTFCDI, OPTFCDIE, OPTFCDINT, OPTFCDST, OPTFCDSTCF, OPTFCDSTN, OPTFCFD, OPTFCFEI, OPTFCFI, OPTFCFIE, OPTFCFINT, OPTFCFST, OPTFCFSTCF, OPTFCFSTN, OPTFCID, OPTFCIF, OPTFCINTD, OPTFCINTF, OPTFCONS, OPTFCSTD, OPTFCSTDCF, OPTFCSTF, OPTFCSTFCF, OPTFDAB, OPTFDACN, OPTFDADD, OPTFDASN, OPTFDATN, OPTFDATT, OPTFDAV, OPTFDCE, OPTFDCOS, OPTFDCSH, OPTFDDIV, OPTFDEXP, OPTFDFL, OPTFDINF, OPTFDLN, OPTFDLOG, OPTFDMO, OPTFDMUL, OPTFDNAN, OPTFDNANVL, OPTFDNEG, OPTFDNINF, OPTFDNNAN, OPTFDPO, OPTFDREM, OPTFDRO, OPTFDRTN, OPTFDSDV, OPTFDSG, OPTFDSIN, OPTFDSM, OPTFDSNH, OPTFDSQR, OPTFDSUB, OPTFDTNH, OPTFDTR, OPTFDVAR, OPTFDWNAV, OPTFDWNSDV, OPTFDWNSM, OPTFDWNVAR, OPTFFAB, OPTFFADD, OPTFFAV, OPTFFCE, OPTFFDIV, OPTFFFL, OPTFFINF, OPTFFMO, OPTFFMUL, OPTFFNAN, OPTFFNANVL, OPTFFNEG, OPTFFNINF, OPTFFNNAN, OPTFFREM, OPTFFRO, OPTFFSDV, OPTFFSG, OPTFFSM, OPTFFSQR, OPTFFSUB, OPTFFTR, OPTFFVAR, OPTFFWNAV, OPTFFWNSDV, OPTFFWNSM, OPTFFWNVAR, OPTFOLLOWING, OPTFRMTZ, OPTFSTLST, OPTFSTLSTM, OPTFTEST, OPTFTESTD, OPTGPID, OPTGRE, OPTGSID, OPTGUID, OPTHAKSL, OPTHASH, OPTHCDIST, OPTHCDISTM, OPTHDRANK, OPTHDRANKM, OPTHPRANK, OPTHPRANKM, OPTHRANK, OPTHRANKM, OPTHTR, OPTIAND, OPTICMP, OPTICONVERT, OPTIDN, OPTIDS2C, OPTIDSI, OPTIIADD, OPTIIDS, OPTIIDSS, OPTIISUB, OPTIIX, OPTIIYM, OPTIIYMS, OPTIMGBLOB, OPTIN, OPTINDIV, OPTINMUL, OPTINS2, OPTINS4, OPTINSC, OPTINSERTXML, OPTINSXML, OPTINTN, OPTIOR, OPTISEMPTY, OPTISNOTEMPTY, OPTISNOTSET, OPTISSET, OPTISTM, OPTISTMS, OPTISTYPE, OPTISTZ, OPTISTZS, OPTITME, OPTITMES, OPTITN, OPTITR, OPTITTZ, OPTITTZS, OPTITZ2C1, OPTITZ2C2, OPTITZ2TS, OPTITZ2TSTZ, OPTITZA2S, OPTITZS2A, OPTIYM2C, OPTIYMI, OPTKSTEST, OPTLBC, OPTLBID, OPTLBL2R, OPTLCAT, OPTLCL2C, OPTLCNV, OPTLCNVT, OPTLDIIF, OPTLDIOF, OPTLEA, OPTLEN2, OPTLEN4, OPTLENC, OPTLICONVERT, OPTLIK2, OPTLIK2E, OPTLIK2N, OPTLIK2NE, OPTLIK4, OPTLIK4E, OPTLIK4N, OPTLIK4NE, OPTLIKC, OPTLIKCE, OPTLIKCN, OPTLIKCNE, OPTLINS, OPTLINSB, OPTLIST, OPTLKO, OPTLLEN, OPTLLENB, OPTLLIK, OPTLLOW, OPTLLPD, OPTLLTR, OPTLN, OPTLNLIK, OPTLNLOW, OPTLNN, OPTLNUPR, OPTLNVL, OPTLOG, OPTLREPL, OPTLRPD, OPTLRTR, OPTLRXINSTR, OPTLRXLIKE, OPTLRXNLIKE, OPTLRXREPLACE, OPTLRXSUBSTR, OPTLSBS, OPTLSBSB, OPTLSVI, OPTLTOB, OPTLTR, OPTLTRM, OPTLUPR, OPTLVL, OPTMEDIAN, OPTMEMBER, OPTMINE, OPTMKNULL, OPTMKXML, OPTMNN, OPTMODE, OPTMOID, OPTMREF, OPTMRG, OPTMSEA, OPTMSED, OPTMSIA, OPTMSID, OPTMSR, OPTMST, OPTMSUA, OPTMSUD, OPTMWTEST, OPTN2R, OPTNCLOB, OPTNCR, OPTNDGRF, OPTNDY, OPTNICOMBINE, OPTNIEXTRACT, OPTNII, OPTNIIDS, OPTNIIYM, OPTNINF, OPTNISTYP, OPTNIX, OPTNLC, OPTNLIF, OPTNLS, OPTNNAN, OPTNNANVL, OPTNNINF, OPTNNNAN, OPTNOTBETWEEN, OPTNOTIN, OPTNOTMEMBER, OPTNOTSUBMS, OPTNPTB, OPTNREM, OPTNTI, OPTNTIN, OPTNTUB4, OPTNTUB8, OPTOBY, OPTOCHK, OPTOID, OPTOLCIC, OPTOP2C, OPTOPASN, OPTOR, OPTOVLPC, OPTOVLPS, OPTPAR, OPTPAR_1, OPTPARGID, OPTPARGID_1, OPTPCONS, OPTPCONT, OPTPDISC, OPTPKOV, OPTPLS, OPTPMSC, OPTPMST, OPTPNUM, OPTPRECEDING, OPTR2C, OPTR2N, OPTR2OID, OPTRANGE, OPTRAVGX, OPTRAVGY, OPTRAW2BF, OPTRCNT, OPTRDTM, OPTREF, OPTREFVAL, OPTRES, OPTREW, OPTRICT, OPTRMTD, OPTROWS, OPTRPL, OPTRR2, OPTRSLP, OPTRSXX, OPTRSXY, OPTRSYY, OPTRTB, OPTRTN, OPTRTOH, OPTRTR, OPTRTRI, OPTRTUR, OPTRXCOMPILE, OPTRXINSTR, OPTRXLIKE, OPTRXNLIKE, OPTRXREPLACE, OPTRXSUBSTR, OPTSBS2, OPTSBS4, OPTSBSC, OPTSDV, OPTSDVP, OPTSDVS, OPTSESTZ, OPTSET, OPTSETZN, OPTSIIDS, OPTSIIYM, OPTSIN, OPTSISTM, OPTSISTZ, OPTSITME, OPTSITTZ, OPTSM2CM, OPTSMCSE, OPTSNH, OPTSPAIS, OPTSPALIAS, OPTSPASSIGN, OPTSPCELL, OPTSPCURRENT, OPTSPCURRENT2, OPTSPFORINLIST, OPTSPFORLIKE, OPTSPFORLOOP, OPTSPIS, OPTSPISANY, OPTSPISPRESENT, OPTSPPNTV, OPTSPPRES, OPTSPPREVIOUS, OPTSPPTNNV, OPTSQR, OPTSRCSE, OPTST2C, OPTSTMI, OPTSTZ2C, OPTSTZI, OPTSUBMS, OPTT2TTZ1, OPTT2TTZ2, OPTTAB, OPTTAD, OPTTAN, OPTTAV, OPTTCA, OPTTCE, OPTTCN, OPTTCO, OPTTCR, OPTTDE, OPTTDI, OPTTDP, OPTTEQ, OPTTFB, OPTTFD, OPTTFDF, OPTTFL, OPTTFN, OPTTGE, OPTTGP, OPTTGP2, OPTTGT, OPTTHX, OPTTIC, OPTTINLA, OPTTINLO, OPTTIS, OPTTLB, OPTTLC, OPTTLE, OPTTLK, OPTTLK2, OPTTLN, OPTTLO, OPTTLP, OPTTLT, OPTTM2C, OPTTMEI, OPTTMI, OPTTML, OPTTMN, OPTTMO, OPTTMU, OPTTMX, OPTTMZ2C, OPTTNC, OPTTNE, OPTTNG, OPTTNH, OPTTNHX, OPTTNK, OPTTNK2, OPTTNN, OPTTNNC, OPTTNS, OPTTNU, OPTTNV, OPTTNV2, OPTTOREF, OPTTPA, OPTTPO, OPTTPR, OPTTRA, OPTTRC, OPTTREAT, OPTTRIM, OPTTRIM_BOTH, OPTTRMLD, OPTTRMTR, OPTTRNC, OPTTRO, OPTTRP, OPTTRTB, OPTTS2DAT1, OPTTS2DAT2, OPTTS2ITZ, OPTTS2TSTZ1, OPTTS2TSTZ2, OPTTSB, OPTTSG, OPTTSI, OPTTSM, OPTTSS, OPTTST, OPTTSTCF, OPTTSTN, OPTTSTZ2ITZ, OPTTSTZ2TS1, OPTTSTZ2TS2, OPTTSU, OPTTSX, OPTTSZ, OPTTTESTIP, OPTTTESTIPD, OPTTTESTIU, OPTTTESTIUD, OPTTTESTO, OPTTTESTOD, OPTTTESTP, OPTTTESTPD, OPTTTR, OPTTTZ2T1, OPTTTZ2T2, OPTTTZI, OPTTUA, OPTTUC, OPTTUN, OPTTUP, OPTTVL, OPTTVLCF, OPTTXI, OPTTXL, OPTTXU, OPTTZOFF, OPTUAG, OPTUB4TN, OPTUB8TN, OPTUDC, OPTUEN, OPTUMKXML, OPTUNBOUNDED_FOLLOWING, OPTUNBOUNDED_PRECEDING, OPTUNIS, OPTUOP, OPTUPDX, OPTUREQ, OPTURGE, OPTURGT, OPTURLE, OPTURLT, OPTURNE, OPTURTB, OPTURTC, OPTVAR, OPTVARP, OPTVARS, OPTVECAND, OPTVECBIT, OPTVECOR, OPTVECXOR, OPTVFIL, OPTVREF, OPTVVD, OPTWIDBUC, OPTWITH, OPTWNAVG, OPTWNCNT, OPTWNDRANK, OPTWNFNNV, OPTWNFRST, OPTWNFSTLST, OPTWNLAG, OPTWNLAST, OPTWNLEAD, OPTWNLNNV, OPTWNMAX, OPTWNMIN, OPTWNNTILE, OPTWNOBY, OPTWNPBY, OPTWNPCONT, OPTWNPDISC, OPTWNPRANK, OPTWNPTILE, OPTWNRANK, OPTWNRAT2R, OPTWNROWNUM, OPTWNSTD, OPTWNSUM, OPTWNUAG, OPTWNVAR, OPTWSRTEST, OPTWSRTESTD, OPTXCONC, OPTXISVLD, OPTXMLCDATA, OPTXMLCNV, OPTXMLCOLATTVAL, OPTXMLCOLELEM, OPTXMLCOMMENT, OPTXMLCONT, OPTXMLELEMENT, OPTXMLEXSTS, OPTXMLEXTR, OPTXMLEXVAL, OPTXMLGEN, OPTXMLPARSE, OPTXMLPI, OPTXMLROOT, OPTXMLTRANS, OPTXPTHATG, OPTXPTHIDX, OPTXPTHOP, OPTXTRCT, OPTXTXT2SQLT, OPTXUTC

Fields inherited from interface oracle.javatools.parser.plsql.symtab.PtnodInternals

PTNOD_BLOCK, PTNOD_FMLPART

Fields inherited from interface oracle.javatools.parser.plsql.data.PtnodConstants

PTNOD_ADT, PTNOD_ADT_CMPON_OBJECT, PTNOD_ADT_CMPON_SUBPRG, PTNOD_ADTBODY, PTNOD_ADTBODY_SUBPRG, PTNOD_base, PTNOD_C_ARRAY_DEF, PTNOD_CURSOR, PTNOD_ENUM_TY_DEF, PTNOD_ERROR, PTNOD_LITERAL, PTNOD_max, PTNOD_NAME, PTNOD_PKG, PTNOD_RECORD_TY_DEF, PTNOD_REF_CURSOR_TY_DEF, PTNOD_ROOT, PTNOD_SUBPRG, PTNOD_SUBTY_DEF, PTNOD_TABLE_TYPE, PTNOD_TBL_TY_DEF, PTNOD_TY_DEF, PTNOD_TYPE, PTNOD_UNCNSTRNED_ARRAY_DEF, PTNOD_VARIABLE, QCNOD_EXPRESSION

Constructor Summary

SqlDriver()

Method Summary

protected AST	allocateNode(int kind)
protected void	begin_exception_handler()
protected boolean	checkpoint()
protected static short	comp_qcodfdef(short operator)
static boolean	dtn(int curToken) True if the parameter is a data type name according to dtndef.h.
protected void	end_exception_handler()
protected void	error(int code)
protected void	error(int code, java.lang.String message)
protected void	errorExpecting(int a)
protected void	errorExpecting(int a, int b)
protected void	errorUnexpected()
protected void	finishNode()
protected java.lang.String	getTokenSource()
protected java.lang.String	getTokenSource(int startOffset)
static boolean	idn(int curToken)
protected void	internalError()
protected void	ips() Initialize Parsing State
static boolean	lit(int curToken)
static java.lang.String	lookupErrorMessage(int code)
protected void	nextToken(int tk) Require that the current token match the given parameter.
protected void	nextToken(int tk1, int tk2) Require that the current token match one of the given parameters.
protected boolean	node(int ty) Pushes a node of the specified type onto the stack.
protected void	notImplementedYet(java.lang.String message)
protected static short	opn_qcodfdef(short operator)
protected boolean	optionalToken(int tk) If the current token matches the given parameter, consume it and return true.
protected boolean	optionalToken(int tk1, int tk2) If the current token matches one of the given parameters, consume it and return true.
protected void	pop() Pops a node off the top of the stack.
protected SqlColdef	qcopCreateCol()
protected SqlOdmCost	qcopCreateCost() Create a COST for Oracle Data Mining
protected SqlFrodef	qcopCreateFrom()
protected SqlGbydef	qcopCreateGby(int gbytyp)
protected SqlAjndef	qcopCreateJoin()
protected SqlLogdef	qcopCreateLog(SqlOptdef predp, SqlLogdef logandp, SqlLogdef logorp)
protected SqlOdmModel	qcopCreateModel() Create a MODEL for Oracle Data Mining
protected SqlOdmdef	qcopCreateOdm(short opttyp, short numArgs)
protected SqlOptdef	qcopCreateOpt(short opttyp, short numArgs)
protected SqlPvtdef	qcopCreatePivot(java.lang.String pivot_clause)
protected SqlQbcdef	qcopCreateQbc() Note that in the qcpi files, there is a qcopCreateQbp not a qcopCreateObc.
protected SqlQbcdef	qcopCreateQbc(short opttyp, short numArgs) Note that in the qcpi files, there is a qcopCreateQbp not a qcopCreateObc.
protected SqlSeldef	qcopCreateSel()
protected SqlColdef	qcopCreateStarCol(java.lang.String uname, java.lang.String tname)
protected SqlStrdef	qcopCreateStr(byte strtyp)
protected SqlTypdef	qcopCreateTyp(java.lang.String typName)
protected short	qcopgonm() Looks up the current token as a SQL operator.
protected SqlOptdef	qcopxla(SqlLogdef logp) QCOP Xlate a Logdef into an Arithmetic expression
protected void	qcpi_xmlcolop(int token_id) Matches XMLColElem, XMLColAttVal
protected boolean	qcpi_xmlelement() Matches XMLELEMENT()
protected boolean	qcpi_xmlparse() Matches XMLPARSE ()
protected void	qcpiaex() QCPI parse Arithmetic EXpression
protected void	qcpibex() parse Boolean EXpression
protected void	qcpibexo() PaRSe a Boolean EXpression as an Operand
protected void	qcpibnu()
protected void	qcpibtl() QCPI Build Type List
protected void	qcpibva()
protected int	qcpichtx() QCPI CHeck for a Table eXpression
protected boolean	qcpicnm(int flags) QCPI parse Column NaMe
protected void	qcpicst(int typ, boolean ansi) QCPI parse CaST or NCTIMG
protected void	qcpicwk() QCPI parse a Commit WorK command
protected void	qcpicwm() QCPI Column With Modifier
protected java.lang.String	qcpidbnm() parse a DataBase (link) NaMe
protected void	qcpidel() QCPI parse a DELete statement
protected boolean	qcpidft() QCPI parse DeFaulT keyword
PlsqlRoot	qcpidrv()
protected PlsqlRoot	qcpidrv(BaseSqlLayer.Context begin) DRiVer
PlsqlRoot	qcpidrv(int input)
protected int	qcpieli() QCPI parse Expression LIst
protected void	qcpifbt() QCPI parse a FlashBack Table statement
protected boolean	qcpifun()
protected SqlOpndef	qcpigslit(byte stype, java.lang.String s)
protected java.lang.String	qcpiidn() parse an IDeNtifier
protected int	qcpiilb(int tkn) QCPI Is current token a Literal (or a Bind that was orig.
protected void	qcpiins() QCPI parse an INSert statement
protected void	qcpiiot() QCPI parse the Is Of Type predicate
protected void	qcpiips() QCPI Initialize Parse for new Sql fragment
protected SqlOptdef	qcpilcl0() parse Logical CLause
protected void	qcpiltb() QCPI parse Lock TaBle command
protected void	qcpimrto(boolean parseoid) QCPI, MakeRef operator, parse Tablename or Oid literal
protected void	qcpioidl() QCPI parse an OID Literal
protected void	qcpiono(short operator, int n, int x) QCPI Operate on N Operands
protected void	qcpiopr(short operator, java.lang.String operatorSource) QCPI OpeRate
protected int	qcpiord() QCPI parse ORDer by clause
protected void	qcpiParseDataType() Parse data type
protected void	qcpiParseInlist() qcpiParseInlist - QCPI parse single and multi-column in-list expressions This function parses in-list of the forms 1.
protected int	qcpipby() QCPI parse Partition BY clause
protected void	qcpipcle() QCPI Parse Complex Local Expressions
protected SqlOpndef	qcpipop() QCPI POP operand off parse stack
protected void	qcpippdn() QCPI Parse a Possibly Dotted Name
protected boolean	qcpippm() QCPI Parse Projection Modifier
protected void	qcpipra(SqlColdef coldef) Trick used: when nested attributes names are defined, colcnm will point to the koksnnm field of koksn instead of merely an idndef.
protected java.lang.String[]	qcpiprax(java.lang.String name)
protected void	qcpipre() QCPI parse PREdicate
protected void	qcpipsh(SqlOpndef opnp) QCPI PuSH operand on stack
protected void	qcpipsqn() parse a Possibly Schema Qualified Name
protected void	qcpiptex(int typ) QCPI Parse nested Table EXpression
protected void	qcpiqex() QCPI parse Query EXpression
protected void	qcpiqry() QCPI parse QueRY
protected void	qcpirol() QCPI parse a ROLlback command
protected void	qcpisel(SqlQbcdef queryBlock) QCPI parse SELect list
protected int	qcpispci() QCPI parse SPreadsheet Cell Index
protected void	qcpisps() qcpisps - Parse Spreadsheets parses SQL Spreadsheet clause according to the following syntax diagram: <spreadsheet clause> ::= SPREADSHEET <global-opt> [REFERENCE ON <ref-name> ON (<query>) <pby-dby-mea> <ref-opt> ...] [MAIN <main-name>] <pby-dby-mea> <main-opt> <rule-options> ( <update rule> [,...] ) <ref-opt> ::= [IGNORE NAV] | [KEEP NAV] [UNIQUE DIMENSION | UNIQUE SINGLE REFERENCE] <rule-options> ::= [RULES [UPSERT | UPDATE] [ AUTOMATIC ORDER | SEQUENTIAL ORDER] ] [ITERATE (n) [UNTIL <condition>]] <global-opt> ::= <ref-opt> <ret-opt> <ret-opt> ::= RETURN {ALL|UPDATE} ROWS <main-opt> ::= <ref-opt> <pby-dby-mea> ::= [PARTITION BY (<cols>)] DIMENSION BY (<cols>) MEASURES (<cols>) <cols> ::= <single col> [,....] <single col> ::= <column> [[AS] <alias name>] | <expression> [AS] <alias name> <update-rule> ::= <cell-reference> = <rhsexpr> <cell-reference> ::= <measure-column> <cell-index> <cell-index> ::= <open-brkt> [ <expr> | <dimension column> = <expr> | <existential-loop-index> | <qualified-loop-index> {, .........} ] <close-brkt> <qualified-loop-index> := FOR [ <conditional-looping-construct> | <membership-condition> ] <conditional-looping-construct> ::= [<like-condition> | <column> ] FROM <expr> TO <expr> [INCREMENT | DECREMENT] <number> <membership-condition> ::= <expr> IN <expr-list> | <expr-list> IN <expr-list> <like-condition> ::= <column> LIKE <string> <existential-loop-index> ::= <condition> | [ <column> = ] ANY <open-brkt> := [ <close-brkt> := ] <rhs-expr> ::= <expr> | <cell-reference> | <cell-aggregation> <cell-aggregation> ::= <aggregate-function> <cell-index>
protected void	qcpispt() QCPI parse a SavePoinT command
protected boolean	qcpissqx() QCPI parse Scalar SubQuery eXpression
protected void	qcpistr(byte stype)
protected void	qcpistxn() QCPI parse a Set TXN command
protected SqlQbcdef	qcpisub(byte nestop) QCPI parse SUBquery Note: qcpisub is supposed to return a qbpdef*.
protected boolean	qcpitda() QCPI parse Table Dot Asterisk
protected SqlFrodef	qcpitnam() Parse Table NAMe.
protected void	qcpitnm(int flags, int atype) QCPI parse Table NaMe
protected boolean	qcpitrt() QCPI parse the TReaT as expression
protected boolean	qcpitxfc() QCPI parse Table eXpression in the From Clause
protected void	qcpitxs() QCPI parse a TeXt Specification
protected void	qcpiupd() QCPI parse an UPDate statement
protected void	qcpiups() QCPI parse an UPSert (MERGE)statement (Upsert has been changed to merge) MERGE INTO <tab> D USING <tab> S ON ( D.col1 = S.col1 ....
protected void	qcpivwq() QCPI parse VieW Query block
protected SqlOpndef[]	qcpiwth() QCPI parse With list.
protected void	restore_context(BaseSqlLayer.Context context) Restores the saved lexer context.
static boolean	rw(int curToken)
protected BaseSqlLayer.Context	save_context() Saves the current lexer context.
void	setTextBuffer(ReadTextBuffer textBuffer) Convenience method that calls through to the lexer's setTextBuffer method.
void	setXmlTableClauseProcessor(XMLTableClauseProcessor proc)
protected void	skipToken() Consumes the current token.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

INPUT_CMD

public static final int INPUT_CMD

Parse as a SQL command.

See Also:

Constant Field Values

INPUT_BEX

public static final int INPUT_BEX

Parse as a boolean expression.

See Also:

Constant Field Values

INPUT_AEX

public static final int INPUT_AEX

Parse as a Arithmetic expression.

See Also:

Constant Field Values

INPUT_SEX

public static final int INPUT_SEX

Parse as a SELECT list expression

See Also:

Constant Field Values

QCPIILB_LITERAL

protected static final int QCPIILB_LITERAL

found a real literal

See Also:

Constant Field Values

QCPIILB_BIND

protected static final int QCPIILB_BIND

found an internal bind (was originally a literal)

See Also:

Constant Field Values

QCPIILB_NONE

protected static final int QCPIILB_NONE

found neither

See Also:

Constant Field Values

QCPICNMF_UTAB

protected static final int QCPICNMF_UTAB

<user> DOT notation ok

See Also:

Constant Field Values

QCPICNMF_ROWID

protected static final int QCPICNMF_ROWID

ROWID allowed here

See Also:

Constant Field Values

QCPICNMF_OUTERJOIN

protected static final int QCPICNMF_OUTERJOIN

outer-join OK

See Also:

Constant Field Values

QCPICNMF_FOUNDNEW

protected static final int QCPICNMF_FOUNDNEW

found NEW before function name

See Also:

Constant Field Values

QCPICNMF_INSLIST

protected static final int QCPICNMF_INSLIST

columns part of insert list

See Also:

Constant Field Values

ctxoct

protected int ctxoct

Variable taken from common SQL parser state.

prxops

protected SqlOpndef[] prxops

pointer to operand stack

prxopc

protected int prxopc

operand count

curFrodef

protected SqlFrodef curFrodef

current table name in FROM clause

curOrddef

protected SqlOrddef[] curOrddef

current ORDER BY clause

KOKB_EXTYP_NOTTBL

public static final int KOKB_EXTYP_NOTTBL

not a table expression

See Also:

Constant Field Values

KOKB_EXTYP_FUNC

public static final int KOKB_EXTYP_FUNC

function (not a table expression)

See Also:

Constant Field Values

KOKB_EXTYP_SUBQYCOLL

public static final int KOKB_EXTYP_SUBQYCOLL

collection subquery

See Also:

Constant Field Values

KOKB_EXTYP_SUBQYTHE

public static final int KOKB_EXTYP_SUBQYTHE

the subquery

See Also:

Constant Field Values

KOKB_EXTYP_CURSOR

public static final int KOKB_EXTYP_CURSOR

CURSOR (subquery)

See Also:

Constant Field Values

KOKB_EXTYP_TBSQ

public static final int KOKB_EXTYP_TBSQ

TABLE (subquery), also THE (subquery)

See Also:

Constant Field Values

KOKB_EXTYP_CAST

public static final int KOKB_EXTYP_CAST

CAST(expression AS nt_type)

See Also:

Constant Field Values

KOKB_EXTYP_MSET

public static final int KOKB_EXTYP_MSET

MULTISET(subquery)

See Also:

Constant Field Values

KOKB_EXTYP_NTCIMG

public static final int KOKB_EXTYP_NTCIMG

nested table column image

See Also:

Constant Field Values

KOKB_EXTYP_CARDNL

public static final int KOKB_EXTYP_CARDNL

Cardinality function exp.

See Also:

Constant Field Values

FROFTA

public static final int FROFTA

table allowed here

See Also:

Constant Field Values

FROFVE

public static final int FROFVE

view allowed here

See Also:

Constant Field Values

FROFCL

public static final int FROFCL

cluster allowed here

See Also:

Constant Field Values

FROFSYN

public static final int FROFSYN

original reference was to a synonym

See Also:

Constant Field Values

FROFALIAS

public static final int FROFALIAS

alias is specified

See Also:

Constant Field Values

FROFPRC

public static final int FROFPRC

procedure, function, package, or sequence allowed here

See Also:

Constant Field Values

FROFRM

public static final int FROFRM

remote table/view allowed here

See Also:

Constant Field Values

FROFFXT

public static final int FROFFXT

fixed table

See Also:

Constant Field Values

FROFALOK

public static final int FROFALOK

alias ok; flg to prstnm; NOT STORED in froflg

See Also:

Constant Field Values

FROFNDEP

public static final int FROFNDEP

place no dependency on this one

See Also:

Constant Field Values

FROFEXPV

public static final int FROFEXPV

this fro resulted from a view expansion

See Also:

Constant Field Values

FROFSUBQ

public static final int FROFSUBQ

subquery in from clause

See Also:

Constant Field Values

FROFODN

public static final int FROFODN

Owner.Name was specified in original sql

See Also:

Constant Field Values

FROFRDO

public static final int FROFRDO

table is from a read only

See Also:

Constant Field Values

FROFPPK

public static final int FROFPPK

if set, remote function name is of the format [<fronuser>.][<fronobject>.]<*froncoln>@fronnode if not set , then it is of the format [<fronuser>.]<fronobject>@fronnode

See Also:

Constant Field Values

FROFSEQ

public static final int FROFSEQ

marks frodef as a sequence frodef

See Also:

Constant Field Values

FROFAJ

public static final int FROFAJ

this fro involved in anti join

See Also:

Constant Field Values

FROFOJ

public static final int FROFOJ

this fro involved in outer join

See Also:

Constant Field Values

FROFUNUSED

public static final int FROFUNUSED

UNUSED -- used to be TQ fro

See Also:

Constant Field Values

FROFDFN

public static final int FROFDFN

K_MNT: default view name used

See Also:

Constant Field Values

FROFLNGNM

public static final int FROFLNGNM

this fro's tni is a LoNG NaMe

See Also:

Constant Field Values

FROFNSTOK

public static final int FROFNSTOK

Nested table's Storage Table access OK

See Also:

Constant Field Values

FROFSWP

public static final int FROFSWP

swap sides of join

See Also:

Constant Field Values

FROFTBSQ

public static final int FROFTBSQ

TABLE (subquery)

See Also:

Constant Field Values

FROFTHE

public static final int FROFTHE

backward compatibility

See Also:

Constant Field Values

FROFTBX

public static final int FROFTBX

TABLE expression

See Also:

Constant Field Values

FROFNTBC

public static final int FROFNTBC

nested table column

See Also:

Constant Field Values

FROFMP

public static final int FROFMP

manual partition, pass 1

See Also:

Constant Field Values

FROFPXNM

public static final int FROFPXNM

Partition eXtended NaMe frodef was created to represent an argument passed to a function - this frodef must be hung off qbcfncfr

See Also:

Constant Field Values

FROFFUNC

public static final int FROFFUNC

See Also:

Constant Field Values

FROFNLAG

public static final int FROFNLAG

Null-augment this table

See Also:

Constant Field Values

FROFINTR

public static final int FROFINTR

frodef's view has instead-of trigger

See Also:

Constant Field Values

FROFKPT

public static final int FROFKPT

this is a key-preserved table

See Also:

Constant Field Values

FROFFAKE

public static final int FROFFAKE

fro is a fake object (IOT only)

See Also:

Constant Field Values

OCTCTB

public static final int OCTCTB

create table

See Also:

Constant Field Values

OCTINS

public static final int OCTINS

insert

See Also:

Constant Field Values

OCTSEL

public static final int OCTSEL

select

See Also:

Constant Field Values

OCTCCL

public static final int OCTCCL

create cluster

See Also:

Constant Field Values

OCTACL

public static final int OCTACL

alter cluster

See Also:

Constant Field Values

OCTUPD

public static final int OCTUPD

update

See Also:

Constant Field Values

OCTDEL

public static final int OCTDEL

delete

See Also:

Constant Field Values

OCTDCL

public static final int OCTDCL

drop cluster

See Also:

Constant Field Values

OCTCIX

public static final int OCTCIX

create index

See Also:

Constant Field Values

OCTDIX

public static final int OCTDIX

drop index

See Also:

Constant Field Values

OCTAIX

public static final int OCTAIX

alter index

See Also:

Constant Field Values

OCTDTB

public static final int OCTDTB

drop table

See Also:

Constant Field Values

OCTCSQ

public static final int OCTCSQ

create sequence

See Also:

Constant Field Values

OCTASQ

public static final int OCTASQ

alter sequence

See Also:

Constant Field Values

OCTATB

public static final int OCTATB

alter table

See Also:

Constant Field Values

OCTDSQ

public static final int OCTDSQ

drop sequence

See Also:

Constant Field Values

OCTGRA

public static final int OCTGRA

grant

See Also:

Constant Field Values

OCTREV

public static final int OCTREV

revoke

See Also:

Constant Field Values

OCTCSY

public static final int OCTCSY

create synonym

See Also:

Constant Field Values

OCTDSY

public static final int OCTDSY

drop synonym

See Also:

Constant Field Values

OCTCVW

public static final int OCTCVW

create view

See Also:

Constant Field Values

OCTDVW

public static final int OCTDVW

drop view

See Also:

Constant Field Values

OCTVIX

public static final int OCTVIX

validate index

See Also:

Constant Field Values

OCTCPR

public static final int OCTCPR

create procedure

See Also:

Constant Field Values

OCTAPR

public static final int OCTAPR

alter procedure

See Also:

Constant Field Values

OCTLTB

public static final int OCTLTB

lock table

See Also:

Constant Field Values

OCTNOP

public static final int OCTNOP

no operation

See Also:

Constant Field Values

OCTRNM

public static final int OCTRNM

rename

See Also:

Constant Field Values

OCTCMT

public static final int OCTCMT

comment

See Also:

Constant Field Values

OCTAUD

public static final int OCTAUD

audit

See Also:

Constant Field Values

OCTNOA

public static final int OCTNOA

noaudit

See Also:

Constant Field Values

OCTCED

public static final int OCTCED

create database link

See Also:

Constant Field Values

OCTDED

public static final int OCTDED

drop database link

See Also:

Constant Field Values

OCTCDB

public static final int OCTCDB

create database

See Also:

Constant Field Values

OCTADB

public static final int OCTADB

alter database

See Also:

Constant Field Values

OCTCRS

public static final int OCTCRS

create rollback segment

See Also:

Constant Field Values

OCTARS

public static final int OCTARS

alter rollback segment

See Also:

Constant Field Values

OCTDRS

public static final int OCTDRS

drop rollback segment

See Also:

Constant Field Values

OCTCTS

public static final int OCTCTS

create tablespace

See Also:

Constant Field Values

OCTATS

public static final int OCTATS

alter tablespace

See Also:

Constant Field Values

OCTDTS

public static final int OCTDTS

drop tablespace

See Also:

Constant Field Values

OCTASE

public static final int OCTASE

alter session

See Also:

Constant Field Values

OCTAUR

public static final int OCTAUR

alter user

See Also:

Constant Field Values

OCTCWK

public static final int OCTCWK

commit

See Also:

Constant Field Values

OCTROL

public static final int OCTROL

rollback

See Also:

Constant Field Values

OCTSPT

public static final int OCTSPT

savepoint

See Also:

Constant Field Values

OCTPLS

public static final int OCTPLS

pl/sql execute

See Also:

Constant Field Values

OCTSET

public static final int OCTSET

set transaction

See Also:

Constant Field Values

OCTASY

public static final int OCTASY

alter system switch log

See Also:

Constant Field Values

OCTXPL

public static final int OCTXPL

explain

See Also:

Constant Field Values

OCTCUS

public static final int OCTCUS

create user

See Also:

Constant Field Values

OCTCRO

public static final int OCTCRO

create role

See Also:

Constant Field Values

OCTDUS

public static final int OCTDUS

drop user

See Also:

Constant Field Values

OCTDRO

public static final int OCTDRO

drop role

See Also:

Constant Field Values

OCTSER

public static final int OCTSER

set role

See Also:

Constant Field Values

OCTCSC

public static final int OCTCSC

create schema

See Also:

Constant Field Values

OCTCCF

public static final int OCTCCF

create control file

See Also:

Constant Field Values

OCTATR

public static final int OCTATR

Alter tracing

See Also:

Constant Field Values

OCTCTG

public static final int OCTCTG

create trigger

See Also:

Constant Field Values

OCTATG

public static final int OCTATG

alter trigger

See Also:

Constant Field Values

OCTDTG

public static final int OCTDTG

drop trigger

See Also:

Constant Field Values

OCTANT

public static final int OCTANT

analyze table

See Also:

Constant Field Values

OCTANI

public static final int OCTANI

analyze index

See Also:

Constant Field Values

OCTANC

public static final int OCTANC

analyze cluster

See Also:

Constant Field Values

OCTCPF

public static final int OCTCPF

create profile

See Also:

Constant Field Values

OCTDPF

public static final int OCTDPF

drop profile

See Also:

Constant Field Values

OCTAPF

public static final int OCTAPF

alter profile

See Also:

Constant Field Values

OCTDPR

public static final int OCTDPR

drop procedure

See Also:

Constant Field Values

OCTARC

public static final int OCTARC

alter resource cost

See Also:

Constant Field Values

OCTCSL

public static final int OCTCSL

create snapshot log

See Also:

Constant Field Values

OCTASL

public static final int OCTASL

alter snapshot log

See Also:

Constant Field Values

OCTDSL

public static final int OCTDSL

drop snapshot log

See Also:

Constant Field Values

OCTCSN

public static final int OCTCSN

create snapshot

See Also:

Constant Field Values

OCTASN

public static final int OCTASN

alter snapshot

See Also:

Constant Field Values

OCTDSN

public static final int OCTDSN

drop snapshot

See Also:

Constant Field Values

OCTCTY

public static final int OCTCTY

create type

See Also:

Constant Field Values

OCTDTY

public static final int OCTDTY

drop type

See Also:

Constant Field Values

OCTARO

public static final int OCTARO

alter role

See Also:

Constant Field Values

OCTATY

public static final int OCTATY

alter type

See Also:

Constant Field Values

OCTCYB

public static final int OCTCYB

create type body

See Also:

Constant Field Values

OCTAYB

public static final int OCTAYB

alter type body

See Also:

Constant Field Values

OCTDYB

public static final int OCTDYB

drop type body

See Also:

Constant Field Values

OCTDLB

public static final int OCTDLB

drop library

See Also:

Constant Field Values

OCTTTB

public static final int OCTTTB

truncate table

See Also:

Constant Field Values

OCTTCL

public static final int OCTTCL

truncate cluster

See Also:

Constant Field Values

OCTCBM

public static final int OCTCBM

create bitmapfile

See Also:

Constant Field Values

OCTAVW

public static final int OCTAVW

alter view

See Also:

Constant Field Values

OCTDBM

public static final int OCTDBM

drop bitmapfile

See Also:

Constant Field Values

OCTSCO

public static final int OCTSCO

set constraints

See Also:

Constant Field Values

OCTCFN

public static final int OCTCFN

create function

See Also:

Constant Field Values

OCTAFN

public static final int OCTAFN

alter function

See Also:

Constant Field Values

OCTDFN

public static final int OCTDFN

drop function

See Also:

Constant Field Values

OCTCPK

public static final int OCTCPK

create package

See Also:

Constant Field Values

OCTAPK

public static final int OCTAPK

alter package

See Also:

Constant Field Values

OCTDPK

public static final int OCTDPK

drop package

See Also:

Constant Field Values

OCTCPB

public static final int OCTCPB

create package body

See Also:

Constant Field Values

OCTAPB

public static final int OCTAPB

alter package body

See Also:

Constant Field Values

OCTDPB

public static final int OCTDPB

drop package body

See Also:

Constant Field Values

OCTCDR

public static final int OCTCDR

create directory

See Also:

Constant Field Values

OCTDDR

public static final int OCTDDR

drop directory

See Also:

Constant Field Values

OCTCLB

public static final int OCTCLB

create library

See Also:

Constant Field Values

OCTCJV

public static final int OCTCJV

create java

See Also:

Constant Field Values

OCTAJV

public static final int OCTAJV

alter java

See Also:

Constant Field Values

OCTDJV

public static final int OCTDJV

drop java

See Also:

Constant Field Values

OCTCOP

public static final int OCTCOP

create opertaor

See Also:

Constant Field Values

OCTCIT

public static final int OCTCIT

create indextype

See Also:

Constant Field Values

OCTDIT

public static final int OCTDIT

drop indextype

See Also:

Constant Field Values

OCTAIT

public static final int OCTAIT

reserver for alter indextype

See Also:

Constant Field Values

OCTDOP

public static final int OCTDOP

drop operator

See Also:

Constant Field Values

OCTAST

public static final int OCTAST

associate statistics

See Also:

Constant Field Values

OCTDST

public static final int OCTDST

disassociate statistics

See Also:

Constant Field Values

OCTCAL

public static final int OCTCAL

call method

See Also:

Constant Field Values

OCTCSM

public static final int OCTCSM

create summary

See Also:

Constant Field Values

OCTASM

public static final int OCTASM

alter summary

See Also:

Constant Field Values

OCTDSM

public static final int OCTDSM

drop summary

See Also:

Constant Field Values

OCTCDM

public static final int OCTCDM

create dimension

See Also:

Constant Field Values

OCTADM

public static final int OCTADM

alter dimension

See Also:

Constant Field Values

OCTDDM

public static final int OCTDDM

drop dimension

See Also:

Constant Field Values

OCTCCT

public static final int OCTCCT

create context

See Also:

Constant Field Values

OCTDCT

public static final int OCTDCT

drop context

See Also:

Constant Field Values

OCTASO

public static final int OCTASO

alter outline

See Also:

Constant Field Values

OCTCSO

public static final int OCTCSO

create outline

See Also:

Constant Field Values

OCTDSO

public static final int OCTDSO

drop outline

See Also:

Constant Field Values

OCT_OBSOLETE

public static final int OCT_OBSOLETE

former update indexes

See Also:

Constant Field Values

OCTAOP

public static final int OCTAOP

alter operator

See Also:

Constant Field Values

OCTCEP

public static final int OCTCEP

create encryption profile

See Also:

Constant Field Values

OCTAEP

public static final int OCTAEP

alter encryption profile

See Also:

Constant Field Values

OCTDEP

public static final int OCTDEP

drop encryption profile

See Also:

Constant Field Values

OCTCSP

public static final int OCTCSP

create spfile from pfile

See Also:

Constant Field Values

OCTCPS

public static final int OCTCPS

create pfile from spfile

See Also:

Constant Field Values

OCTUPS

public static final int OCTUPS

upsert

See Also:

Constant Field Values

OCTCPW

public static final int OCTCPW

change password

See Also:

Constant Field Values

OCTUJI

public static final int OCTUJI

update join index

See Also:

Constant Field Values

OCTASYN

public static final int OCTASYN

alter synonym

See Also:

Constant Field Values

OCTADG

public static final int OCTADG

alter disk group

See Also:

Constant Field Values

OCTCDG

public static final int OCTCDG

create disk group

See Also:

Constant Field Values

OCTDDG

public static final int OCTDDG

drop disk group

See Also:

Constant Field Values

OCTALB

public static final int OCTALB

alter library

See Also:

Constant Field Values

OCTPRB

public static final int OCTPRB

purge user recyclebin

See Also:

Constant Field Values

OCTPDB

public static final int OCTPDB

purge dba recyclebin

See Also:

Constant Field Values

OCTPTS

public static final int OCTPTS

purge tablespace

See Also:

Constant Field Values

OCTPTB

public static final int OCTPTB

purge table

See Also:

Constant Field Values

OCTPIX

public static final int OCTPIX

purge index

See Also:

Constant Field Values

OCTUDP

public static final int OCTUDP

undrop object

See Also:

Constant Field Values

OCTDDB

public static final int OCTDDB

drop database

See Also:

Constant Field Values

OCTFBD

public static final int OCTFBD

flashback database

See Also:

Constant Field Values

OCTFBT

public static final int OCTFBT

flashback table

See Also:

Constant Field Values

OPT_comps

public static final short[] OPT_comps

OPT_opns

public static final byte[] OPT_opns

curToken

protected int curToken

The current lexer token.

lastEndOffset

protected int lastEndOffset

The end offset of the previous token.

handlerDepth

protected int handlerDepth

The exception handler depth. If any exception handler is active, then we throw RuntimeExceptions in order to unroll the stack.

lexer

protected oracle.javatools.parser.plsql.syntax.BaseSqlLexer lexer

The associated PlsqlLexer.

textBuffer

protected ReadTextBuffer textBuffer

The input text buffer.

stackTop

protected AST stackTop

The top of the AST stack.

stack

protected AST[] stack

The AST stack.

stackHeight

protected int stackHeight

The depth of the AST stack.

root

protected PtnodRoot root

The root node of the parse tree.

lastCheckpoint

protected int lastCheckpoint

The last checkpoint.

errorCount

protected int errorCount

The number of errors.

lastErrorOffset

protected int lastErrorOffset

The offset of the last error

resources

protected static final oracle.javatools.resource.BundleHelper resources

PTERR_base

public static final int PTERR_base

Base value for PTERR_* constants.

See Also:

Constant Field Values

PTERR_ALTER_ATTR_MODIFY

public static final int PTERR_ALTER_ATTR_MODIFY

See Also:

Constant Field Values

PTERR_ALTER_TYPE

public static final int PTERR_ALTER_TYPE

See Also:

Constant Field Values

PTERR_EXPECTING_IDENTIFIER

public static final int PTERR_EXPECTING_IDENTIFIER

See Also:

Constant Field Values

PTERR_EXPECTING_N

public static final int PTERR_EXPECTING_N

See Also:

Constant Field Values

PTERR_EXPECTING_STRING

public static final int PTERR_EXPECTING_STRING

See Also:

Constant Field Values

PTERR_INTERNAL_ERROR

public static final int PTERR_INTERNAL_ERROR

See Also:

Constant Field Values

PTERR_INVALID_INTERVAL

public static final int PTERR_INVALID_INTERVAL

See Also:

Constant Field Values

PTERR_INVALID_PREDICATE

public static final int PTERR_INVALID_PREDICATE

See Also:

Constant Field Values

PTERR_INVALID_TYPE_DEF

public static final int PTERR_INVALID_TYPE_DEF

See Also:

Constant Field Values

PTERR_NOT_IMPLEMENTED_YET

public static final int PTERR_NOT_IMPLEMENTED_YET

See Also:

Constant Field Values

PTERR_PARAMETER_STYLE

public static final int PTERR_PARAMETER_STYLE

See Also:

Constant Field Values

PTERR_PARTITION

public static final int PTERR_PARTITION

See Also:

Constant Field Values

PTERR_SQLJ_USING

public static final int PTERR_SQLJ_USING

See Also:

Constant Field Values

PTERR_UNEXPECTED_TOKEN

public static final int PTERR_UNEXPECTED_TOKEN

See Also:

Constant Field Values

QCERR_EXPECTING_IDENTIFIER

public static final int QCERR_EXPECTING_IDENTIFIER

See Also:

Constant Field Values

QCERR_INVALID_CASE

public static final int QCERR_INVALID_CASE

See Also:

Constant Field Values

QCERR_INVALID_DBNM

public static final int QCERR_INVALID_DBNM

See Also:

Constant Field Values

QCERR_INVALID_EXPRESSION

public static final int QCERR_INVALID_EXPRESSION

See Also:

Constant Field Values

QCERR_INVALID_HEURISTIC

public static final int QCERR_INVALID_HEURISTIC

See Also:

Constant Field Values

QCERR_INVALID_INTERVAL

public static final int QCERR_INVALID_INTERVAL

See Also:

Constant Field Values

QCERR_INVALID_JOIN

public static final int QCERR_INVALID_JOIN

See Also:

Constant Field Values

QCERR_INVALID_LOCK_TABLE

public static final int QCERR_INVALID_LOCK_TABLE

See Also:

Constant Field Values

QCERR_INVALID_PREDICATE

public static final int QCERR_INVALID_PREDICATE

See Also:

Constant Field Values

QCERR_INVALID_USING

public static final int QCERR_INVALID_USING

See Also:

Constant Field Values

QCERR_LISTSIZE_MISMATCH

public static final int QCERR_LISTSIZE_MISMATCH

See Also:

Constant Field Values

QCERR_MISSING_EXPRESSION

public static final int QCERR_MISSING_EXPRESSION

See Also:

Constant Field Values

QCERR_NO_ALIAS

public static final int QCERR_NO_ALIAS

See Also:

Constant Field Values

QCERR_NO_CUBE_ROLLUP

public static final int QCERR_NO_CUBE_ROLLUP

See Also:

Constant Field Values

QCERR_NO_INLINE_VIEW

public static final int QCERR_NO_INLINE_VIEW

See Also:

Constant Field Values

QCERR_NO_LIST_OPERANDS

public static final int QCERR_NO_LIST_OPERANDS

See Also:

Constant Field Values

QCERR_NO_SAMPLE

public static final int QCERR_NO_SAMPLE

See Also:

Constant Field Values

QCERR_RELOP_NEED_ANYALL

public static final int QCERR_RELOP_NEED_ANYALL

See Also:

Constant Field Values

QCERR_SUBQUERY_REQUIRED

public static final int QCERR_SUBQUERY_REQUIRED

See Also:

Constant Field Values

QCERR_TOO_MANY_OPERANDS

public static final int QCERR_TOO_MANY_OPERANDS

See Also:

Constant Field Values

QCERR_UNEXPECTED_EOS

public static final int QCERR_UNEXPECTED_EOS

See Also:

Constant Field Values

QCERR_UNKNOWN

public static final int QCERR_UNKNOWN

See Also:

Constant Field Values

QCERR_UNRECOGNISED_PIVOT_CLAUSE

public static final int QCERR_UNRECOGNISED_PIVOT_CLAUSE

See Also:

Constant Field Values

QCERR_UNRECOGNISED_UNPIVOT_CLAUSE

public static final int QCERR_UNRECOGNISED_UNPIVOT_CLAUSE

See Also:

Constant Field Values

Constructor Detail

SqlDriver

public SqlDriver()

Method Detail

qcpidrv

public final PlsqlRoot qcpidrv()

qcpidrv

public final PlsqlRoot qcpidrv(int input)

qcpidrv

protected final PlsqlRoot qcpidrv(BaseSqlLayer.Context begin)

DRiVer

qcpitxs

protected final void qcpitxs()

QCPI parse a TeXt Specification

qcpirol

protected final void qcpirol()

QCPI parse a ROLlback command

qcpispt

protected final void qcpispt()

QCPI parse a SavePoinT command

qcpicwk

protected final void qcpicwk()

QCPI parse a Commit WorK command

qcpistxn

protected final void qcpistxn()

QCPI parse a Set TXN command

qcpiltb

protected final void qcpiltb()

QCPI parse Lock TaBle command

qcpisps

protected final void qcpisps()

qcpisps - Parse Spreadsheets parses SQL Spreadsheet clause according to the following syntax diagram: <spreadsheet clause> ::= SPREADSHEET <global-opt> [REFERENCE ON <ref-name> ON (<query>) <pby-dby-mea> <ref-opt> ...] [MAIN <main-name>] <pby-dby-mea> <main-opt> <rule-options> ( <update rule> [,...] ) <ref-opt> ::= [IGNORE NAV] | [KEEP NAV] [UNIQUE DIMENSION | UNIQUE SINGLE REFERENCE] <rule-options> ::= [RULES [UPSERT | UPDATE] [ AUTOMATIC ORDER | SEQUENTIAL ORDER] ] [ITERATE (n) [UNTIL <condition>]] <global-opt> ::= <ref-opt> <ret-opt> <ret-opt> ::= RETURN {ALL|UPDATE} ROWS <main-opt> ::= <ref-opt> <pby-dby-mea> ::= [PARTITION BY (<cols>)] DIMENSION BY (<cols>) MEASURES (<cols>) <cols> ::= <single col> [,....] <single col> ::= <column> [[AS] <alias name>] | <expression> [AS] <alias name> <update-rule> ::= <cell-reference> = <rhsexpr> <cell-reference> ::= <measure-column> <cell-index> <cell-index> ::= <open-brkt> [ <expr> | <dimension column> = <expr> | <existential-loop-index> | <qualified-loop-index> {, .........} ] <close-brkt> <qualified-loop-index> := FOR [ <conditional-looping-construct> | <membership-condition> ] <conditional-looping-construct> ::= [<like-condition> | <column> ] FROM <expr> TO <expr> [INCREMENT | DECREMENT] <number> <membership-condition> ::= <expr> IN <expr-list> | <expr-list> IN <expr-list> <like-condition> ::= <column> LIKE <string> <existential-loop-index> ::= <condition> | [ <column> = ] ANY <open-brkt> := [ <close-brkt> := ] <rhs-expr> ::= <expr> | <cell-reference> | <cell-aggregation> <cell-aggregation> ::= <aggregate-function> <cell-index>

qcpispci

protected final int qcpispci()

QCPI parse SPreadsheet Cell Index

qcpipra

protected final void qcpipra(SqlColdef coldef)

Trick used: when nested attributes names are defined, colcnm will point to the koksnnm field of koksn instead of merely an idndef. In addition to an embedded ADT name, koksn points to a list of ADT names (koksl's). Note that we can substitute a koksn for an idndef because the koksnnm field in koksn is an embedded idndef; if COLFNAS is set, it indicates that a koksn exists and colp-> colcnm is now pointing to the koksnnm field of koksn.

qcpiprax

protected final java.lang.String[] qcpiprax(java.lang.String name)

qcpippdn

protected final void qcpippdn()

QCPI Parse a Possibly Dotted Name

qcpippm

protected final boolean qcpippm()

QCPI Parse Projection Modifier

qcpicst

protected final void qcpicst(int typ,
                             boolean ansi)

QCPI parse CaST or NCTIMG

qcpibtl

protected final void qcpibtl()

QCPI Build Type List

qcpiiot

protected final void qcpiiot()

QCPI parse the Is Of Type predicate

qcpitrt

protected final boolean qcpitrt()

QCPI parse the TReaT as expression

qcpimrto

protected final void qcpimrto(boolean parseoid)

QCPI, MakeRef operator, parse Tablename or Oid literal

qcpichtx

protected final int qcpichtx()

QCPI CHeck for a Table eXpression

qcpiptex

protected final void qcpiptex(int typ)

QCPI Parse nested Table EXpression

qcpissqx

protected final boolean qcpissqx()

QCPI parse Scalar SubQuery eXpression

qcpitxfc

protected final boolean qcpitxfc()

QCPI parse Table eXpression in the From Clause

qcpi_xmlcolop

protected final void qcpi_xmlcolop(int token_id)

Matches XMLColElem, XMLColAttVal

qcpi_xmlparse

protected final boolean qcpi_xmlparse()

Matches XMLPARSE ()

qcpi_xmlelement

protected final boolean qcpi_xmlelement()

Matches XMLELEMENT()

qcpiins

protected final void qcpiins()

QCPI parse an INSert statement

qcpiupd

protected final void qcpiupd()

QCPI parse an UPDate statement

qcpidel

protected final void qcpidel()

QCPI parse a DELete statement

qcpiqex

protected final void qcpiqex()

QCPI parse Query EXpression

qcpisub

protected final SqlQbcdef qcpisub(byte nestop)

QCPI parse SUBquery Note: qcpisub is supposed to return a qbpdef*. In qcpi2.c, I'm seeing the return of qcpisub being cast to be a qbcdef*. Consider in qcpi4.c qcpiupd, the result of qcpisub is stored in a qbcdef*. I don't understand the intent, so for now I'm going to return a SqlQbcdef. (acyu 12/8/2003)

qcpivwq

protected final void qcpivwq()

QCPI parse VieW Query block

qcpiqry

protected final void qcpiqry()

QCPI parse QueRY

qcpitnm

protected final void qcpitnm(int flags,
                             int atype)

QCPI parse Table NaMe

qcpitnam

protected final SqlFrodef qcpitnam()

Parse Table NAMe. Use this routine when you just want the following elements parsed and returned. Parser assumed looking at the first token (identifier). Use prstnm (no 'A') instead if you need a frodef set up as well.

qcpiord

protected final int qcpiord()

QCPI parse ORDer by clause

qcpifbt

protected void qcpifbt()

QCPI parse a FlashBack Table statement

qcpiwth

protected final SqlOpndef[] qcpiwth()

QCPI parse With list. return an array of operations, each operation ihas two operands, the alias name the query

qcpisel

protected void qcpisel(SqlQbcdef queryBlock)

QCPI parse SELect list

qcpipby

protected final int qcpipby()

QCPI parse Partition BY clause

qcpiups

protected final void qcpiups()

QCPI parse an UPSert (MERGE)statement (Upsert has been changed to merge) MERGE INTO <tab> D USING <tab> S ON ( D.col1 = S.col1 .... ) WHEN MATCHED THEN UPDATE SET ... WHEN NOT MATCHED THEN INSERT (col1,col2) VALUES (col1,col2)

setXmlTableClauseProcessor

public final void setXmlTableClauseProcessor(XMLTableClauseProcessor proc)

qcpiaex

protected final void qcpiaex()

QCPI parse Arithmetic EXpression

qcpicnm

protected final boolean qcpicnm(int flags)

QCPI parse Column NaMe

Returns:

True if this is a function call.

qcpistr

protected final void qcpistr(byte stype)

qcpibnu

protected final void qcpibnu()

qcpibva

protected final void qcpibva()

qcpioidl

protected final void qcpioidl()

QCPI parse an OID Literal

qcpiilb

protected final int qcpiilb(int tkn)

QCPI Is current token a Literal (or a Bind that was orig. a literal) ?

qcpidft

protected final boolean qcpidft()

QCPI parse DeFaulT keyword

qcpibexo

protected final void qcpibexo()

PaRSe a Boolean EXpression as an Operand

qcpieli

protected final int qcpieli()

QCPI parse Expression LIst

qcpicwm

protected final void qcpicwm()

QCPI Column With Modifier

qcpifun

protected final boolean qcpifun()

qcpipcle

protected final void qcpipcle()

QCPI Parse Complex Local Expressions

qcpiParseDataType

protected final void qcpiParseDataType()

Parse data type

qcpitda

protected boolean qcpitda()

QCPI parse Table Dot Asterisk

qcpigslit

protected SqlOpndef qcpigslit(byte stype,
                              java.lang.String s)

qcpibex

protected final void qcpibex()

parse Boolean EXpression

qcpipre

protected void qcpipre()

QCPI parse PREdicate

qcpilcl0

protected final SqlOptdef qcpilcl0()

parse Logical CLause

qcpiParseInlist

protected final void qcpiParseInlist()

qcpiParseInlist - QCPI parse single and multi-column in-list expressions This function parses in-list of the forms 1. expr IN (<expr-list>) 2. (<expr-list>) IN (<expr-list>)

save_context

protected final BaseSqlLayer.Context save_context()

Saves the current lexer context.

restore_context

protected void restore_context(BaseSqlLayer.Context context)

Restores the saved lexer context.

qcpiips

protected final void qcpiips()

QCPI Initialize Parse for new Sql fragment

qcpipsh

protected final void qcpipsh(SqlOpndef opnp)

QCPI PuSH operand on stack

qcpipop

protected final SqlOpndef qcpipop()

QCPI POP operand off parse stack

qcpiopr

protected final void qcpiopr(short operator,
                             java.lang.String operatorSource)

QCPI OpeRate

qcpiono

protected final void qcpiono(short operator,
                             int n,
                             int x)

QCPI Operate on N Operands

Parameters:

n - # operands

x - # extra operands

getTokenSource

protected final java.lang.String getTokenSource()

getTokenSource

protected final java.lang.String getTokenSource(int startOffset)

qcpiidn

protected final java.lang.String qcpiidn()

parse an IDeNtifier

qcpidbnm

protected final java.lang.String qcpidbnm()

parse a DataBase (link) NaMe

qcpipsqn

protected final void qcpipsqn()

parse a Possibly Schema Qualified Name

lit

public static final boolean lit(int curToken)

Returns:

True if the parameter represents a literal.

idn

public static final boolean idn(int curToken)

Returns:

True if the parameter may be a valid identifier.

rw

public static final boolean rw(int curToken)

Returns:

True if the parameter is a reserved word.

dtn

public static boolean dtn(int curToken)

True if the parameter is a data type name according to dtndef.h.

qcopCreateLog

protected final SqlLogdef qcopCreateLog(SqlOptdef predp,
                                        SqlLogdef logandp,
                                        SqlLogdef logorp)

qcopCreateStr

protected final SqlStrdef qcopCreateStr(byte strtyp)

qcopCreateCol

protected final SqlColdef qcopCreateCol()

qcopCreateStarCol

protected final SqlColdef qcopCreateStarCol(java.lang.String uname,
                                            java.lang.String tname)

qcopCreateOpt

protected final SqlOptdef qcopCreateOpt(short opttyp,
                                        short numArgs)

qcopCreateOdm

protected final SqlOdmdef qcopCreateOdm(short opttyp,
                                        short numArgs)

qcopCreateQbc

protected final SqlQbcdef qcopCreateQbc()

Note that in the qcpi files, there is a qcopCreateQbp not a qcopCreateObc.

qcopCreateQbc

protected final SqlQbcdef qcopCreateQbc(short opttyp,
                                        short numArgs)

Note that in the qcpi files, there is a qcopCreateQbp not a qcopCreateObc. This is for the set operations like UNION and UNION ALL

qcopCreateSel

protected final SqlSeldef qcopCreateSel()

qcopCreateGby

protected final SqlGbydef qcopCreateGby(int gbytyp)

qcopCreateTyp

protected final SqlTypdef qcopCreateTyp(java.lang.String typName)

qcopCreateJoin

protected final SqlAjndef qcopCreateJoin()

qcopCreateFrom

protected final SqlFrodef qcopCreateFrom()

qcopCreatePivot

protected final SqlPvtdef qcopCreatePivot(java.lang.String pivot_clause)

qcopCreateModel

protected final SqlOdmModel qcopCreateModel()

Create a MODEL for Oracle Data Mining

qcopCreateCost

protected final SqlOdmCost qcopCreateCost()

Create a COST for Oracle Data Mining

qcopxla

protected final SqlOptdef qcopxla(SqlLogdef logp)

QCOP Xlate a Logdef into an Arithmetic expression

qcopgonm

protected final short qcopgonm()

Looks up the current token as a SQL operator. Does not consume the current token.

Returns:

the operator code from SqlOperators or OPT_invalid if none.

opn_qcodfdef

protected static final short opn_qcodfdef(short operator)

comp_qcodfdef

protected static final short comp_qcodfdef(short operator)

allocateNode

protected AST allocateNode(int kind)

finishNode

protected void finishNode()

ips

protected void ips()

Initialize Parsing State

setTextBuffer

public void setTextBuffer(ReadTextBuffer textBuffer)

Convenience method that calls through to the lexer's setTextBuffer method.

nextToken

protected final void nextToken(int tk)

Require that the current token match the given parameter. If it does, consume the token. If not, generate an error.

nextToken

protected final void nextToken(int tk1,
                               int tk2)

Require that the current token match one of the given parameters. If it does, consume the token. If not, generate an error.

optionalToken

protected final boolean optionalToken(int tk)

If the current token matches the given parameter, consume it and return true. Otherwise, return false.

optionalToken

protected final boolean optionalToken(int tk1,
                                      int tk2)

If the current token matches one of the given parameters, consume it and return true. Otherwise, return false.

skipToken

protected final void skipToken()

Consumes the current token.

node

protected final boolean node(int ty)

Pushes a node of the specified type onto the stack.

Returns:

True if a node of the given type was shifted. If so, the subtree's offsets will have been updated and the lexer position set. Otherwise, false is returned.

pop

protected final void pop()

Pops a node off the top of the stack.

checkpoint

protected final boolean checkpoint()

begin_exception_handler

protected final void begin_exception_handler()

end_exception_handler

protected final void end_exception_handler()

notImplementedYet

protected void notImplementedYet(java.lang.String message)

internalError

protected void internalError()

error

protected void error(int code)

error

protected void error(int code,
                     java.lang.String message)

errorExpecting

protected void errorExpecting(int a)

errorExpecting

protected void errorExpecting(int a,
                              int b)

errorUnexpected

protected void errorUnexpected()

lookupErrorMessage

public static java.lang.String lookupErrorMessage(int code)