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

E13403-05

oracle.javatools.parser.plsql.syntax
Class SqlDriver

java.lang.Object
  extended by 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 [.][.]<*froncoln>@fronnode if not set , then it is of the format [.]@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
           
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
           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  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 [REFERENCE ON ON () ...] [MAIN ] ( [,...] ) ::= [IGNORE NAV] | [KEEP NAV] [UNIQUE DIMENSION | UNIQUE SINGLE REFERENCE] ::= [RULES [UPSERT | UPDATE] [ AUTOMATIC ORDER | SEQUENTIAL ORDER] ] [ITERATE (n) [UNTIL ]] ::= ::= RETURN {ALL|UPDATE} ROWS ::= ::= [PARTITION BY ()] DIMENSION BY () MEASURES () ::= [,....] ::= [[AS] <alias name>] | [AS] <alias name> ::= = ::= ::= [ | = | | {, .........} ] := FOR [ | ] ::= [ | ] FROM TO [INCREMENT | DECREMENT] ::= IN | IN ::= LIKE ::= | [ = ] ANY := [ := ] ::= | | ::= <aggregate-function>
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 D USING 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
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 [.][.]<*froncoln>@fronnode if not set , then it is of the format [.]@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
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 [REFERENCE ON ON () ...] [MAIN ] ( [,...] ) ::= [IGNORE NAV] | [KEEP NAV] [UNIQUE DIMENSION | UNIQUE SINGLE REFERENCE] ::= [RULES [UPSERT | UPDATE] [ AUTOMATIC ORDER | SEQUENTIAL ORDER] ] [ITERATE (n) [UNTIL ]] ::= ::= RETURN {ALL|UPDATE} ROWS ::= ::= [PARTITION BY ()] DIMENSION BY () MEASURES () ::= [,....] ::= [[AS] <alias name>] | [AS] <alias name> ::= = ::= ::= [ | = | | {, .........} ] := FOR [ | ] ::= [ | ] FROM TO [INCREMENT | DECREMENT] ::= IN | IN ::= LIKE ::= | [ = ] ANY := [ := ] ::= | | ::= <aggregate-function>


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 D USING 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 () 2. () IN ()


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()

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)

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

E13403-05

Copyright © 1997, 2011, Oracle. All rights reserved.