ColorCode SQL Properties file#

As an example configuration, the properties file below formats SQL source

#
# HTML codes
#
colorcode.area.class: breadcrumbs
colorcode.area.bgcolor: #e3f0e3
colorcode.keyword.font.color: #7f0055
colorcode.keyword.font.bold: true
colorcode.keyword.font.italic: false
colorcode.string.font.color: #2a00ff
colorcode.string.font.bold: false
colorcode.string.font.italic: false
colorcode.number.font.color: #800000
colorcode.number.font.bold: false
colorcode.number.font.italic: false
colorcode.normal.font.color: #000000
colorcode.normal.font.bold: false
colorcode.normal.font.italic: false
colorcode.comment.font.color: #3f7f5f
colorcode.comment.font.bold: false
colorcode.comment.font.italic: true
colorcode.font.bold.on: <b>
colorcode.font.bold.off: </b>
colorcode.font.italic.on: <i>
colorcode.font.italic.off: </i>
colorcode.newline: <br/>
colorcode.space = &nbsp;
    
#
# SQL Keywords
#
colorcode.keywords: SELECT,FROM,WHERE,GROUP,ORDER,AND,OR,AS,\
ON,BY,JOIN,INSERT,UPDATE,MERGE,TRUNCATE,DELETE,INTO,SET,VALUES,\
START,TRANSACTION,BEGIN,WORK,COMMIT,ROLLBACK,CREATE,DROP,TABLE,\
PRIMARY,ALTER,NOT,NULL,KEY,FOREIGN,REFERENCES,ADD,CONSTRAINT,\
SYSDATE,MAX,CASCADE,CONSTRAINTS,DEFAULT,\
CHAR,VARCHAR,VARCHAR2,NUMBER,INTEGER,TIMESTAMP,DATE,TIME,\
LONGVARCHAR,DECIMAL,BIT,TINYINT,SMALLINT,INTEGER,BIGINT,REAL,\
FLOAT,DOUBLE,BINARY,VARBINARY,LONGVARBINARY,BOOLEANCHAR,BOOLEANINT

#
# Program the tokenizer:
#

#tokenizer.commentChar: 
tokenizer.eolIsSignificant: false
tokenizer.lowerCaseMode: false
tokenizer.ordinaryChar: _,-
tokenizer.ordinaryChars: a-z,A-Z,0-9
tokenizer.parseNumbers: true
tokenizer.quoteChar: ',"
tokenizer.slashSlashComments: false
tokenizer.slashStarComments: false
tokenizer.whitespaceChars: \ ,\t
tokenizer.wordChars: a,~

---

<<Back