oracle.javatools.parser.plsql.symtab
Class SqlColdef

java.lang.Object
  oracle.javatools.parser.plsql.symtab.SqlOpndef
      oracle.javatools.parser.plsql.symtab.SqlColdef

All Implemented Interfaces:

PlsqlNode, PtnodConstants, SqlConstants, SqlExpression, SqlOperators

public class SqlColdef
extends SqlOpndef

Field Summary

java.lang.String[]	coladt an abstract or user define datatype reference
java.lang.String	colcnm column name
java.lang.String	colnode network node name
boolean	colOuterJoin outerjoin flag
java.lang.String	coltnm table name
java.lang.String	colunm user name

Fields inherited from class oracle.javatools.parser.plsql.symtab.SqlOpndef

EMPTY_ARRAY, m_startOffset, opntyp

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

OPNTATTR, OPNTCOL, OPNTGBY, OPNTLAZ, OPNTLOG, OPNTODM, OPNTOPT, OPNTPLS, OPNTQBP, OPNTSEL, OPNTSTR, OPNTSYS, OPNTTYP, QBCNALL, QBCNANY, QBCNCOLL, QBCNEXISTS, QBCNFORSPCELL, QBCNLEVEL1, QBCNNOTEXISTS, QBCNSINGLE, QBCNSSQ, STRTANY, STRTBIND, STRTCBR, STRTCIOUT, STRTCONS, STRTCORR, STRTCTS, STRTDATE, STRTDBTZ, STRTDFT, STRTFMT, STRTINL, STRTISCYL, STRTITNK, STRTITRT, STRTLEAF, STRTLEVL, STRTMAXV, STRTMQHBC, STRTNULL, STRTPRIO, STRTRNUM, STRTSETR, STRTSTS, STRTSYST, STRTTQC_OBSOLETE, STRTTRG, STRTTVNM, STRTUID, STRTUSER, STRTVAR, STRTVARC

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.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

SqlColdef()

Method Summary

java.lang.String[]	getColumnAndAttributes() Get the column name and the column datatype attributes.
java.lang.String	getColumnBaseName() Get the column name.
java.lang.String	getColumnNodeName() get the column network node name
boolean	getColumnOuterJoin()
java.lang.String	getColumnTableName() Get the columns table name.
java.lang.String	getColumnUserName() Get the colunms user or schema name.
boolean	reallign(java.lang.String schemaName, java.lang.String tableName) Given the table name, review the column name

Methods inherited from class oracle.javatools.parser.plsql.symtab.SqlOpndef

getOperandCount, getOperands, getOperandType, getOperatorType, getStartOffset, getStringText, getStringType, getTreeKind, isWindowFuntion, setWif

Methods inherited from class java.lang.Object

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

Field Detail

colnode

public java.lang.String colnode

network node name

coltnm

public java.lang.String coltnm

table name

colcnm

public java.lang.String colcnm

column name

colunm

public java.lang.String colunm

user name

coladt

public java.lang.String[] coladt

an abstract or user define datatype reference

colOuterJoin

public boolean colOuterJoin

outerjoin flag

Constructor Detail

SqlColdef

public SqlColdef()

Method Detail

getColumnBaseName

public java.lang.String getColumnBaseName()

Get the column name.

This method returns null if the parser thinks that it has a column datatype attribute. That is a name of the form col.attr. See getColumnAndAttributes()

Specified by:

getColumnBaseName in interface SqlExpression

Overrides:

getColumnBaseName in class SqlOpndef

Returns:

column name

getColumnTableName

public java.lang.String getColumnTableName()

Get the columns table name.

Specified by:

getColumnTableName in interface SqlExpression

Overrides:

getColumnTableName in class SqlOpndef

Returns:

table name

getColumnUserName

public java.lang.String getColumnUserName()

Get the colunms user or schema name.

The Parser assume that a name of the form u.t.c is comprised of the user name, table name and column name

Specified by:

getColumnUserName in interface SqlExpression

Overrides:

getColumnUserName in class SqlOpndef

Returns:

user name

getColumnNodeName

public java.lang.String getColumnNodeName()

get the column network node name

Specified by:

getColumnNodeName in interface SqlExpression

Overrides:

getColumnNodeName in class SqlOpndef

Returns:

network node name

getColumnAndAttributes

public java.lang.String[] getColumnAndAttributes()

Get the column name and the column datatype attributes. If getColumnBaseName() returns null, this method will return an array. The first element being the column name, the subsequent elements being the attribute names.

Returns:

column name and datatype attribute names

reallign

public boolean reallign(java.lang.String schemaName,
                        java.lang.String tableName)

Given the table name, review the column name

The parser assumes that a column name with 2 dots is comprised of .

.

This is not necessarily correct. The schema name may be absent, in which case we actually have

..

This method is passed the schema name and the table name. It uses this information to reallign its internal representation of the date to match the table name. If this is not possible it return false and does nothing.

Returns:

true if the reallignment succeeded or was not necessary

getColumnOuterJoin

public boolean getColumnOuterJoin()