editplus sql语法着色 保存为.stx

#TITLE=SQL
; SQL syntax file written by Lizhenzhou.

#DELIMITER=,(){}[]-+*%/="'~!&|<>?:;.
#QUOTATION1='
#QUOTATION2="
#LINECOMMENT=--
#COMMENTON=/*
#COMMENTOFF=*/

#SPECIAL_STX=SQL

#KEYWORD=SQL Tags
;VAR
sql_variant
datetime
smalldatetime
float
real
decimal
money
numeric
NUMBER
NVARCHAR2
smallmoney
bigint
int
smallint
tinyint
bit
ntext
text
image
integer
INT
timestamp
uniqueidentifier
nvarchar
nchar
varchar
VARCHAR2
char
CHARACTER
varbinary
binary
#KEYWORD=Reserved words
ACCESS
ACCESSED
ACCOUNT
ACTIVATE
ADD
ADMIN
ADVISE
AFTER
AGENT
AGGREGATE
ALL
ALLOCATE
ALL_ROWS
ALTER
ALWAYS
ANALYZE
ANCILLARY
AND
ANY
ARCHIVE
ARCHIVELOG
ARRAY
ARRAYLEN
AS
ASC
ASSOCIATE
AT
ATTRIBUTE
ATTRIBUTES
AUDIT
AUTHENTICATED
AUTHID
AUTHORIZATION
AUTO
AUTOALLOCATE
AUTOEXTEND
AUTOMATIC
AUTONOMOUS_TRANSACTION
AVG
BACKUP
BECOME
BEFORE
BEGIN
BEHALF
BETWEEN
BFILE
BIGFILE
BINARY_INTEGER
BINDING
BITMAP
BLOB
BLOCK
BLOCKSIZE
BODY
BOOLEAN
BUFFER_POOL
BUILD
BULK
BULK_ROWCOUNT
BY
BYTE
CACHE
CACHE_INSTANCES
CALL
CALLING
CANCEL
CASCADE
CASE
CAST
CATEGORY
CFILE
CHAINED
CHANGE
CHARACTER
CHAR_CS
CHECK
CHECKBOX
CHECKPOINT
CHILD
CHOOSE
CHUNK
CLASS
CLEAR
CLOB
CLONE
CLOSE
CLOSE_CACHED_OPEN_CURSORS
CLUSTER
CLUSTER_ID
CLUSTER_PROBABILITY
CLUSTER_SET
COALESCE
COBOL
COLLECT
COLUMN
COLUMNS
COLUMN_VALUE
COMMENT
COMMIT
COMMITTED
COMPATIBILITY
COMPILE
COMPLETE
COMPOSITE_LIMIT
COMPRESS
COMPUTE
CONNECT
CONNECT_TIME
CONSIDER
CONSISTENT
CONSTANT
CONSTRAINT
CONSTRAINTS
CONSTRUCTOR
CONTENTS
CONTEXT
CONTINUE
CONTROLFILE
CONVERT
COST
COUNT
CPU_PER_CALL
CPU_PER_SESSION
CREATE
CROSS
CUBE
CURRENT
CURRENT_SCHEMA
CURRENT_USER
CURRVAL
CURSOR
CYCLE
DANGLING
DATA
DATABASE
DATAFILE
DATAFILES
DATAOBJNO
DATE
DAY
DBA
DBA_RECYCLEBIN
DBTIMEZONE
DDL
DEALLOCATE
DEBUG
DEC
DECLARE
DECREMENT
DEFAULT
DEFERRABLE
DEFERRED
DEFINER
DEGREE
DELETE
DEMAND
DEREF
DESC
DESCRIPTION
DETERMINES
DETERMINISTIC
DICTIONARY
DIMENSION
DIRECTORY
DISABLE
DISASSOCIATE
DISCONNECT
DISK
DISKGROUP
DISMOUNT
DISTINCT
DISTRIBUTED
DML
DOUBLE
DROP
DUMP
EACH
ELEMENT
ELSE
ELSIF
ENABLE
END
ENFORCE
ENFORCED
ENTRY
ERRORS
ESCAPE
ESTIMATE
EVENTS
EXCEPT
EXCEPTION
EXCEPTIONS
EXCEPTION_INIT
EXCHANGE
EXCLUDING
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXPIRE
EXPLAIN
EXTEND
EXTENT
EXTENTS
EXTERNAL
EXTERNALLY
FAILED_LOGIN_ATTEMPTS
FAILGROUP
FALSE
FAST
FEATURE_ID
FEATURE_SET
FEATURE_VALUE
FETCH
FILE
FINAL
FIRST
FIRST_ROWS
FLAGGER
FLASHBACK
FLOB
FLUSH
FOR
FORALL
FORCE
FOREIGN
FORTRAN
FOUND
FREELIST
FREELISTS
FREEPOOLS
FRESH
FROM
FULL
FUNCTION
FUNCTIONS
GENERATED
GLOBAL
GLOBALLY
GLOBAL_NAME
GO
GOTO
GRANT
GROUP
GROUPING
GROUPS
GUARANTEE
HASH
HASHKEYS
HAVING
HEADER
HEAP
HIDDEN
HIERARCHY
HIGH
HINT
ID
IDENTIFIED
IDENTIFIER
IDGENERATORS
IDLE_TIME
IF
IFEMPTY
IGNORE
IMMEDIATE
IN
INCLUDING
INCREMENT
INDEX
INDEXED
INDEXES
INDEXTYPE
INDEXTYPES
INDICATOR
IND_PARTITION
INITIAL
INITIALIZED
INITIALLY
INITRANS
INNER
INSERT
INSTANCE
INSTANCES
INSTANTIABLE
INSTEAD
INTERMEDIATE
INTERSECT
INTERVAL
INTO
INVALIDATE
IS
ISOLATION
ISOLATION_LEVEL
ISOPEN
ITERATE
JAVA
JOIN
KEEP
KEY
KILL
LABEL
LANGUAGE
LAST
LAYER
LEFT
LESS
LEVEL
LEVELS
LIBRARY
LIKE
LIMIT
LINK
LIST
LISTS
LOB
LOCAL
LOCATION
LOCATOR
LOCK
LOCKED
LOG
LOGFILE
LOGGING
LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
LONG
LOOP
MAIN
MANAGE
MANAGED
MANAGEMENT
MANUAL
MAP
MAPPING
MASTER
MATCHED
MATERIALIZED
MAX
MAXARCHLOGS
MAXDATAFILES
MAXEXTENTS
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXSIZE
MAXTRANS
MAXVALUE
MEASURES
MEMBER
MERGE
MIN
MINEXTENTS
MINIMIZE
MINIMUM
MINUS
MINVALUE
MLSLABEL
MOD
MODE
MODEL
MODIFY
MODULE
MONITORING
MONTH
MOUNT
MOVE
MOVEMENT
MTS_DISPATCHERS
MULTISET
NAME
NAMED
NATIONAL
NATURAL
NATURALN
NAV
NCHAR_CS
NCLOB
NEEDED
NESTED
NETWORK
NEVER
NEW
NEXT
NEXTVAL
NO
NOARCHIVELOG
NOAUDIT
NOCACHE
NOCOMPRESS
NOCOPY
NOCYCLE
NOFORCE
NOGUARANTEE
NOLOGGING
NOMAPPING
NOMAXVALUE
NOMINIMIZE
NOMINVALUE
NOMONITORING
NONE
NOORDER
NOOVERRIDE
NOPARALLEL
NORELY
NORESETLOGS
NOREVERSE
NORMAL
NOROWDEPENDENCIES
NOSORT
NOT
NOTFOUND
NOTHING
NOVALIDATE
NOWAIT
NULL
NULLS
OBJECT
OBJNO
OBJNO_REUSE
OF
OFF
OFFLINE
OID
OIDINDEX
OLD
ON
ONLINE
ONLY
OPCODE
OPEN
OPERATOR
OPTIMAL
OPTIMIZER_GOAL
OPTION
OR
ORDER
ORGANIZATION
OTHERS
OUT
OUTER
OUTLINE
OVERFLOW
OVERRIDING
OWN
PACKAGE
PACKAGES
PACKED
PARALLEL
PARALLEL_ENABLE
PARAMETERS
PARENT
PARTITION
PARTITIONS
PASSWORD
PASSWORD_GRACE_TIME
PASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_VERIFY_FUNCTION
PCTFREE
PCTINCREASE
PCTTHRESHOLD
PCTUSED
PCTVERSION
PERCENT
PERMANENT
PFILE
PIPE
PIPELINED
PLAN
PLI
PLSQL_DEBUG
PLS_INTEGER
POINT
POSITIVE
POSITIVEN
POST_TRANSACTION
PRAGMA
PREBUILT
PRECISION
PREDICTION
PREDICTION_COST
PREDICTION_DETAILS
PREDICTION_PROBABILITY
PREDICTION_SET
PRESERVE
PRIMARY
PRIOR
PRIVATE
PRIVATE_SGA
PRIVILEGE
PRIVILEGES
PROCEDURE
PROFILE
PUBLIC
PURGE
QUERY
QUEUE
QUOTA
RAISE
RANGE
RAW
RBA
READ
READONLY
READS
REBUILD
RECORD
RECORDS_PER_BLOCK
RECOVER
RECOVERABLE
RECOVERY
RECYCLE
RECYCLEBIN
REDUCED
REDUNDANCY
REF
REFERENCE
REFERENCES
REFERENCING
REFRESH
REJECT
RELATIONAL
RELY
RENAME
REPLACE
REQUIRED
RESET
RESETLOGS
RESIZE
RESOLVE
RESOLVER
RESOURCE
RESTORE
RESTRICT
RESTRICTED
RESTRICT_REFERENCES
RESULT
RESUME
RETENTION
RETURN
RETURNING
REUSE
REVERSE
REVOKE
REWRITE
RIGHT
RNDS
RNPS
ROLE
ROLES
ROLLBACK
ROLLUP
ROW
ROWCOUNT
ROWDEPENDENCIES
ROWID
ROWLABEL
ROWNUM
ROWS
ROWTYPE
RULE
RULES
SAMPLE
SAVEPOINT
SCAN
SCAN_INSTANCES
SCHEMA
SCN
SCOPE
SD_ALL
SD_INHIBIT
SD_SHOW
SECOND
SECTION
SEED
SEGMENT
SEG_BLOCK
SEG_FILE
SELECT
SELECTIVITY
SELF
SEQUENCE
SEQUENTIAL
SERIALIZABLE
SERIALLY_REUSABLE
SESSION
SESSIONS_PER_USER
SESSIONTIMEZONE
SESSION_CACHED_CURSORS
SET
SETS
SHARE
SHARED
SHARED_POOL
SHRINK
SHUTDOWN
SIBLINGS
SIGNTYPE
SINGLE
SIZE
SYS_REFCURSOR
SKIP
SKIP_UNUSABLE_INDEXES
SMALL
SMALLFILE
SMALLINT
SNAPSHOT
SOME
SORT
SOURCE
SPACE
SPECIFICATION
SPFILE
SPLIT
SQL
SQLBUF
SQLCODE
SQLERRM
SQLERROR
SQLSTATE
SQL_TRACE
STANDARD
STANDBY
START
STATEMENT
STATEMENT_ID
STATIC
STATISTICS
STDDEV
STOP
STORAGE
STORE
STRING
STRUCTURE
SUBPARTITION
SUBPARTITIONS
SUBSTITUTABLE
SUBTYPE
SUCCESSFUL
SUM
SUPPLEMENTAL
SUSPEND
SWITCH
SYNONYM
SYS
SYSAUX
SYSDATE
SYSDBA
SYSOPER
SYSTEM
SYS_OP_ENFORCE_NOT_NULL$
SYS_OP_NTCIMG$
TABLE
TABLES
TABLESPACE
TABLESPACE_NO
TABNO
TEMPFILE
TEMPLATE
TEMPORARY
THAN
THE
THEN
THREAD
THROUGH
TIME
TIMEOUT
TIMESTAMP
TIME_ZONE
TO
TOPLEVEL
TRACE
TRACING
TRANSACTION
TRANSITIONAL
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNCATE
TRUST
TRUSTED
TX
TYPE
TYPES
UBA
UID
UNARCHIVED
UNDER
UNDO
UNIFORM
UNION
UNIQUE
UNLIMITED
UNLOCK
UNPACKED
UNRECOVERABLE
UNTIL
UNUSABLE
UNUSED
UPDATABLE
UPDATE
UPDATED
UPPERCASE
UPSERT
UROWID
USAGE
USE
USER
USING
VALIDATE
VALIDATION
VALUE
VALUES
VARIABLE
VARIANCE
VARRAY
VARYING
VERSIONS
VIEW
WAIT
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WNDS
WNPS
WORK
WRITE
XID
XMLSCHEMA
XMLTYPE
YEAR
ZONE

评论

4 楼 qq672076266 2013-07-03  

                

3 楼 xurichusheng 2011-06-09  

在第10行加上
#NUMBER_PATTERN=cpp

2 楼 xurichusheng 2011-06-09  

#KEYWORD=Method
TO_CHAR
NVL
ASCII
CHR
CONCAT
INITCAP
INSTR
LENGTH
LOWER
UPPER
RPAD
LPAD
LTRIM
RTRIM
SUBSTR
REPLACE
SOUNDEX
TRIM
ABS
ACOS
ASIN
ATAN
CEIL
COS
COSH
EXP
FLOOR
LN
LOG
MOD
POWER
ROUND
TRUNC
SIGN
SIN
MAX
COUNT
AVG
TO_NUMBER
TRUNC

1 楼 nwpuxueyong 2011-05-27  

发个评论真不容易。先得回答问题。第一篇文章不知道写的，完全看不懂