Sunday, July 24, 2016

Notepad++ PLSQL Language Syntax Highlight

Ref: http://dwh-consult.de/wp-content/uploads/2016/02/userDefineLang_xml.txt

<NotepadPlus>
 <UserLang name="PL-SQL" ext="pkb pks">
  <Settings>
  <Global caseIgnored="yes"/>
  <TreatAsSymbol comment="yes" commentLine="yes"/>
  <Prefix words1="no" words2="no" words3="no" words4="no"/>
  </Settings>
  <KeywordLists>
   <Keywords name="Delimiters">'00'00</Keywords>
   <Keywords name="Folder+">BEGIN IF</Keywords>
   <Keywords name="Folder-">END</Keywords>
   <Keywords name="Operators">( ) . ; | + &lt; = &gt; :</Keywords>
   <Keywords name="Comment">1/* 2*/ 0--</Keywords>
   <Keywords name="Words1">ABORT ACCEPT ACCESS ADD ALL ALTER
AND ANY ARRAY ARRAYLEN AS ASC ASSERT ASSIGN AT ATTRIBUTES AUDIT
AUTHORIZATION AVG BASE_TABLE BEGIN BETWEEN BINARY_INTEGER BODY BOOLEAN
BY CASE CAST CHAR CHAR_BASE CHECK CLOSE CLUSTER CLUSTERS COLAUTH
COLUMN COMMENT COMMIT COMPRESS CONNECT CONNECTED CONSTANT CONSTRAINT
CRASH CREATE CURRENT CURRVAL CURSOR DATABASE DATA_BASE DATE DBA
DEALLOCATE DEBUGOFF DEBUGON DECLARE DECIMAL DEFAULT DEFINITION DELAY
DELETE DESC DIGITS DISPOSE DISTINCT DO DROP ELSE ELSIF ENABLE END
ENTRY ESCAPE EXCEPTION EXCEPTION_INIT EXCHANGE EXCLUSIVE EXISTS EXIT
EXTERNAL FAST FETCH FILE FOR FORCE FORM FROM FUNCTION GENERIC GOTO
GRANT GROUP HAVING IDENTIFIED IF IN INCREMENT INDEX INDEXES INDICATOR
INITIAL INITRANS INSERT INTERFACE INTERSECT INTO IMMEDIATE IS KEY
LEVEL LIBRARY LIKE LIMITED LOCAL LOCK LOG LOGGING LONG LOOP MASTER
MAXEXTENTS MAXTRANS MEMBER MINEXTENTS MINUS MISLABEL MODE MODIFY
MULTISET NEW NEXT NO NOAUDIT NOCOMPRESS NOLOGGING NOPARALLEL NOT
NOWAIT NUMBER_BASE OBJECT OF OFF OFFLINE ON ONLINE ONLY OPEN OPTION OR
ORDER OUT PACKAGE PARALLEL PARTITION PCTFREE PCTINCREASE PCTUSED
PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIMARY PRIOR PRIVATE PRIVILEGES
PROCEDURE PUBLIC RAISE RANGE RAW READ REBUILD RECORD REF REFERENCES
REFRESH RELEASE REMR RENAME REPLACE RESOURCE RESTRICT RETURN RETURNING
REVERSE REVOKE ROLLBACK ROW ROWID ROWLABEL ROWNUM ROWS RUN SAVEPOINT
SCHEMA SEGMENT SELECT SEPARATE SESSION SET SHARE SNAPSHOT SPACE SQL
SOME SPLIT START STATEMENT STORAGE SUBTYPE SUCCESSFUL SYNONYM TABAUTH
TABLE TABLES TABLESPACE TASK TERMINATE THEN TO TRIGGER TRUNCATE TYPE
UNION UNIQUE UNLIMITED UNRECOVERABLE UNUSABLE UPDATE USE USING
VALIDATE VALUE VALUES VARIABLE VIEW VIEWS WHEN WHENEVER WHERE WHILE
WITH WORK</Keywords>
   <Keywords name="Words2">ACOS ABS ADD_MONTHS ASCII ASIN
ATAN ATAN2 AVERAGE BFILENAME CEIL CHR CHARTOROWID CONCAT CONVERT COS
COSH COUNT DECODE DEREF DUAL DUMP DUP_VAL_ON_INDEX EMPTY ERROR EXP
FALSE FLOOR FOUND GLB GREATEST HEXTORAW INITCAP INSTR INSTRB ISOPEN
LAST_DAY LEAST LENGTH LENGHTB LN LOWER LPAD LTRIM LUB MAKE_REF MAX MIN
MOD MONTHS_BETWEEN NEW_TIME NEXT_DAY NEXTVAL NLS_CHARSET_DECL_LEN
NLS_CHARSET_ID NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_SORT
NLS_UPPER NLSSORT NO_DATA_FOUND NOTFOUND NULL NVL OTHERS POWER
RAWTOHEX REFTOHEX ROUND ROWCOUNT ROWIDTOCHAR RPAD RTRIM SIGN SIN SINH
SQLCODE SQLERRM SQRT SOUNDEX STDDEV SUBSTR SUBSTRB SUM SYSDATE TAN
TANH TO_CHAR TO_DATE TO_LABEL TO_MULTI_BYTE TO_NUMBER TO_SINGLE_BYTE
TRANSLATE TRUE TRUNC UID UPPER USER USERENV VARIANCE VSIZE</Keywords>
   <Keywords name="Words3">BFILE BLOB CHARACTER CLOB DEC
FLOAT INT INTEGER MLSLABEL NATURAL NATURALN NCHAR NCLOB NUMBER NUMERIC
NVARCHAR2 REAL ROWTYPE SIGNTYPE SMALLINT STRING VARCHAR
VARCHAR2</Keywords>
   <Keywords name="Words4"/>
  </KeywordLists>
  <Styles>
   <WordsStyle name="DEFAULT" styleID="11" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="FOLDEROPEN" styleID="12" fgColor="0000FF" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="FOLDERCLOSE" styleID="13" fgColor="0000FF" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="KEYWORD1" styleID="5" fgColor="0000FF" bgColor="FFFFFF" fontName="" fontStyle="1"/>
   <WordsStyle name="KEYWORD2" styleID="6" fgColor="FF8000" bgColor="FFFFFF" fontName="" fontStyle="1"/>
   <WordsStyle name="KEYWORD3" styleID="7" fgColor="FF8080" bgColor="FFFFFF" fontName="" fontStyle="1"/>
   <WordsStyle name="KEYWORD4" styleID="8" fgColor="800040" bgColor="FFFFFF" fontName="" fontStyle="1"/>
   <WordsStyle name="COMMENT" styleID="1" fgColor="008000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="COMMENT LINE" styleID="2" fgColor="008000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="NUMBER" styleID="4" fgColor="FF8000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="OPERATOR" styleID="10" fgColor="FF0000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="DELIMINER1" styleID="14" fgColor="0000A0" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="DELIMINER2" styleID="15" fgColor="008000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
   <WordsStyle name="DELIMINER3" styleID="16" fgColor="000000" bgColor="FFFFFF" fontName="" fontStyle="0"/>
  </Styles>
 </UserLang>
</NotepadPlus>

1 comment:

  1. automation anywhere course
    We at ikxbay are committed to provide industry ready and relevant skill set training to freshers and professionals. Attend 1st 2 live classes for FREE!!

    ReplyDelete