Notepad++ and PLSQL

In addition to my previous post. You also need to add PL/SQL for syntax highlighting. To get that working you need to follow these steps. 1> Goto %APPDATA%\Notepad++ (Start->Run>%APPDATA%\Notepad++) 2> Check for the file userDefineLang.xml 3> If file exists then add following code into it just before tag

        
            
            
            
        
        
            000000
            begin
            end
            ! " % & ( ) * , / : ; ? @ [ \ ] ^ ` | ~ + < = >
            1 2 0#
            ALL ALTER AND ANY ARRAY AS ASC AT AUTHID AVG BETWEEN BINARY_INTEGER BODY BOOLEAN BULK BY CASE CHAR CHAR_BASE CHECK CLOSE CLUSTER COALESCE COLLECT COMMENT COMMIT COMPRESS CONNECT CONSTANT CREATE CURRENT CURRVAL CURSOR DATE DAY DECLARE DECIMAL DEFAULT DELETE DESC DISTINCT DO DROP ELSE ELSIF EXCEPTION EXCLUSIVE EXECUTE EXISTS EXIT EXTENDS EXTRACT FALSE FETCH FLOAT FOR FORALL FROM FUNCTION GOTO GROUP HAVING HEAP HOUR IF IMMEDIATE IN INDEX INDICATOR INSERT INTEGER INTERFACE INTERSECT INTERVAL INTO IS ISOLATION JAVALEVEL LIKE LIMITED LOCK LONG LOOPMAX MIN MINUS MINUTE MLSLABEL MOD MODE MONTH NATURAL NATURALN NEW NEXTVAL NOCOPY NOT NOWAIT NULL NULLIF NUMBER NUMBER_BASE OCIROWID OF ON OPAQUE OPEN OPERATOR OPTION OR ORDER ORGANIZATION OTHERS OUT PACKAGE PARTITION PCTFREE PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIOR PRIVATE PROCEDURE PUBLIC RAISE RANGE RAW REAL RECORD REF RELEASE RETURN REVERSE ROLLBACK ROW ROWID ROWNUM ROWTYPE SAVEPOINT SECOND SELECT SEPARATE SET SHARE SMALLINT SPACE SQL SQLCODE SQLERRM START STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE ABLE THEN TIME TIMESTAMP TIMEZONE_REGION TIMEZONE_ABBR TIMEZONE_MINUTE TIMEZONE_HOUR TO TRIGGER TRUE TYPE UID UNION UNIQUE UPDATE USE USER VALIDATE VALUES VARCHAR VARCHAR2 VARIANCE VIEW WHEN WHENEVER WHERE WHILE WITH WORK WRITE YEAR ZONE
            ac asnp clc cli clp clv cpi cpp cvpa diff epal epcsv fc fl foreach % ft fw gal gc gci gcm gdr ghy gi gl gm gp gps group gsv gsnp gu gv gwmi iex ihy ii ipal ipcsv mi mp nal ndr ni nv oh rdr ri rni rnp rp rsnp rv rvpa sal sasv sc select si sl sleep sort sp spps spsv sv tee where ? write cat cd clear cp h history kill lp ls mount mv popd ps pushd pwd r rm rmdir echo cls chdir copy del dir erase move rd ren set type
            
        
            
            
            
            
            
            
            
            
            
            
            
            
            
            
        
    

4> If file does not exists then create the file and add following code

    
        
            
            
            
        
        
            000000
            begin
            end
            ! " % & ( ) * , / : ; ? @ [ \ ] ^ ` | ~ + < = >
            1 2 0#
            ALL ALTER AND ANY ARRAY AS ASC AT AUTHID AVG BETWEEN BINARY_INTEGER BODY BOOLEAN BULK BY CASE CHAR CHAR_BASE CHECK CLOSE CLUSTER COALESCE COLLECT COMMENT COMMIT COMPRESS CONNECT CONSTANT CREATE CURRENT CURRVAL CURSOR DATE DAY DECLARE DECIMAL DEFAULT DELETE DESC DISTINCT DO DROP ELSE ELSIF EXCEPTION EXCLUSIVE EXECUTE EXISTS EXIT EXTENDS EXTRACT FALSE FETCH FLOAT FOR FORALL FROM FUNCTION GOTO GROUP HAVING HEAP HOUR IF IMMEDIATE IN INDEX INDICATOR INSERT INTEGER INTERFACE INTERSECT INTERVAL INTO IS ISOLATION JAVALEVEL LIKE LIMITED LOCK LONG LOOPMAX MIN MINUS MINUTE MLSLABEL MOD MODE MONTH NATURAL NATURALN NEW NEXTVAL NOCOPY NOT NOWAIT NULL NULLIF NUMBER NUMBER_BASE OCIROWID OF ON OPAQUE OPEN OPERATOR OPTION OR ORDER ORGANIZATION OTHERS OUT PACKAGE PARTITION PCTFREE PLS_INTEGER POSITIVE POSITIVEN PRAGMA PRIOR PRIVATE PROCEDURE PUBLIC RAISE RANGE RAW REAL RECORD REF RELEASE RETURN REVERSE ROLLBACK ROW ROWID ROWNUM ROWTYPE SAVEPOINT SECOND SELECT SEPARATE SET SHARE SMALLINT SPACE SQL SQLCODE SQLERRM START STDDEV SUBTYPE SUCCESSFUL SUM SYNONYM SYSDATE ABLE THEN TIME TIMESTAMP TIMEZONE_REGION TIMEZONE_ABBR TIMEZONE_MINUTE TIMEZONE_HOUR TO TRIGGER TRUE TYPE UID UNION UNIQUE UPDATE USE USER VALIDATE VALUES VARCHAR VARCHAR2 VARIANCE VIEW WHEN WHENEVER WHERE WHILE WITH WORK WRITE YEAR ZONE
            ac asnp clc cli clp clv cpi cpp cvpa diff epal epcsv fc fl foreach % ft fw gal gc gci gcm gdr ghy gi gl gm gp gps group gsv gsnp gu gv gwmi iex ihy ii ipal ipcsv mi mp nal ndr ni nv oh rdr ri rni rnp rp rsnp rv rvpa sal sasv sc select si sl sleep sort sp spps spsv sv tee where ? write cat cd clear cp h history kill lp ls mount mv popd ps pushd pwd r rm rmdir echo cls chdir copy del dir erase move rd ren set type
            
        
            
            
            
            
            
            
            
            
            
            
            
            
            
            
        
    

Enjoy