You are here: Using General SQL Parser > Source Token Types
ContentsIndexHome
PreviousUpNext
Source Token Types
Source Token Types

 

Check TokenType of TSourceToken to find out what's kind of source token it is. 

 

ttDoublehyphenComment, single line comment start with double hyphen, -- this is comment 

ttSlashStarComment, multi line comment start with slash star, /* this is multi line comment */ 

ttWhiteSpace, white space 

ttReturn, new line 

ttIdentifier, identifier,, tokencode is IDENT 

ttkeyword, keyword 

ttNumber, tokencode is FCONST , ICONST 

 

ttSQString, 'this is single quote string', tokencode is SCONST 

ttDQString, "this is double quote string", tokencode is IDENT 

ttDBString, [this is a identifier], tokencode is IDENT 

ttBRString, {this is a identifier}, tokencode is IDENT 

 

ttSqlVar, tokencode is VARIABLE, like this: @varname 

 

ttBindVar, bind variable like this, :bindvarname 

 

ttComma, "," 

ttOpenBracket, "(" 

ttCloseBracket, ")" 

ttOpenSquareBracket, "[" 

ttCloseSquareBracket, "]" 

ttDot, "." 

ttSemicolon, ";" 

ttDolorSign, "$" 

ttColon, ":" 

ttPlus, "+" 

ttMinus, "-" 

ttMulti, "*" 

ttDiv, "/" 

ttHat, "^" 

ttLessThan, "<" 

ttGreaterThan, ">" 

ttEquals, "=" 

ttAtSign, "@" 

ttBitWise, "~","&","|" 

 

ttSingleCharOperator, any other single char operator which tokencode is less than 255 

 

ttMultiCharOperator, multi charater operator, tokencode is CmpOp, Op, LABEL_BEGIN ("<<"), LABEL_END(">>"),ASSIGN_SIGN(":="),DOUBLE_DOT(".."), LEFTJOIN_OP("*="),RIGHTJOIN_OP("=*"),REF_ARROW("->") 

 

Oracle: 

ttSTMT_DELIMITER, / used to separate sql statements. 

ttConcatenationOP, tokencode is ConcatenationOP, "||" 

ttsqlpluscmd, sqlplus command, tokencode is sqlpluscmd. 

 

DB2: 

ttbackslash, "\", db2 use \ for multiline 

 

Use token type together with DBObjType property in TSourceToken

DBObjType can be used to judge what's kind of database object this token represents for. 

check Source token and database object for more.

Gudu software http://www.sqlparser.com
Send comments about this topic.