;Oracle PL-SQL 2000 adicional Syntax highlight Script for Twistpad
;1998 - 2005 (C) Carthago Software

[::Header::]
SyntaxName=PL/SQL
Extensions=SQL
Functions=(^FUNCTION|^PROCEDURE)
Spelling=0 
SpellingContexts=1;2;4
;SpellingContexts=4
delimiters=?%-+/&*=<>|!~^,.:;(){}#*"][\/'«»@
CommentChar=--

[Comment1]
Type=StartStop
Context=1
Priority=10
Scope=0
WholeWordOnly=0
First=--
Last=
Background=Default
Foreground=008000
Italic=1

[Comment2]
Type=StartStop
Context=2
Scope=0
Priority=10
WholeWordOnly=0
First=/*
Last=*/
Background=Default
Foreground=008000
outline=1
Italic=1

[Comment3]
Type=StartStop
Context=13
Scope=0
Priority=10
WholeWordOnly=1
First=rem
Last=
Background=Default
Foreground=008000
outline=1
Italic=1

[Quote]
Type=StartStop
Context=4
Scope=0
Priority=10
WholeWordOnly=0
First='
Last='
Background=Default
Foreground=747474

[INSERTEND]
Type=StartStop
Context=8
Scope=0
Priority=5
WholeWordOnly=0
First=INSERT
Last=;
Background=Default
Foreground=Default
outline=1
beginparagraph=1

[IFEND]
Type=StartStop
Context=9
Scope=0
Priority=5
WholeWordOnly=1
First=IF
Last=END IF;
Background=Default
Foreground=Default
outline=1
beginparagraph=1
smart=1

[UPDATEEND]
Type=StartStop
Context=10
Scope=0
Priority=5
WholeWordOnly=0
First=UPDATE
Last=;
Background=Default
Foreground=Default
outline=1
beginparagraph=1

[DELETETEEND]
Type=StartStop
Context=11
Scope=0
Priority=5
WholeWordOnly=0
First=DELETE
Last=;
Background=Default
Foreground=Default
outline=1
beginparagraph=1

[SQL Keywords]
Type=keyword
Context=102
Scope=0
Priority=6
WholeWordOnly=1
Keyword1=ABORT;ABS;ACCEPT;ACCESS;ACOS;ADD;ADD_MONTHS;AFTER;ALL;ALTER;AND;ANY;APPINFO;ARRAY;ARRAYLEN;ARRAYSIZE;ARRAY;AS;ASC;ASCII;ASIN;ASSERT;ASSIGN;VARRAY
Keyword2=AT;ATAN;ATAN2;AUDIT;AUTHID;AUTHORIZATION;AUTOCOMMIT;AUTOPRINT;AUTOTRACE;AVG;BASE_TABLE;BECOME;BEFORE;BEGIN;BETWEEN;BINARY_INTEGER;BLOCKTERMINATOR;BODY;BOOLEAN;BTITLE;BULK;BY;CASE;CEIL;CHAR;CHAR_BASE;CHARTOROWID;CHECK;CHR;CLOSE;CLUSTER;CLUSTERS
Keyword3=CMDSEP;COLAUTH;COLLECT;COLSEP;COLUMN;COLUMNS;COMMENT;COMMIT;COMPATIBILITY;COMPRESS;CONCAT;CONN;CONNECT;CONSTANT;CONVERT;COPY_COMMIT;COPYTYPECHECK;COS;COSH;COST;COUNT;CRASH;CREATE;CURRENT;CURRVAL;CURSOR;DATA_BASE;DATABASE;DATE;DAY;DBA;DEBUGOFF;DEBUGON;DECIMAL;DECLARE;DECODE;DEFAULT;DEFINE;DEFINITION;DELAY;DELETE;DELTA;DESC
Keyword4=DIGITS;DISPOSE;DISTINCT;DO;DROP;DUMP;EACH;ECHO;EDITFILE;ELSE;ELSIF;EMBEDDED;END;ENTRY;ERRORS;ESCAPE;EXCEPTION_UNIT;EXCEPTION;EXCEPTION_INIT;EXCLUSIVE;EXECUTE;EXISTS;EXIT;EXP;EXTENDS;FALSE;FEEDBACK;FETCH;FILE;FIRST;FLAGGER;FLOAT;FLOOR;FLUSH;FOR;FORALL;FORCE;FORM;FROM;FUNCTION;GENERIC;GOTO;GRANT;GREATEST;GROUP;HAVING;HEADING;HEADSET;HEAP;HEXTORAW;HOUR;INCREMENT;IDENTIFIED;IF;IMMEDIATE;IN;INCREMENT;INDEX;INDEXES;INDICATOR;INITCAP;INITIAL;INSERT;INSTEAD;INSTR;INTEGER;INTERFACE;INTERSECT;INTERVAL;INTO;IS;ISOLATION;JAVA;KEY;LAST;LAST_DAY;LEAST
Keyword5=LENGTH;LEVEL;LIKE;LIMITED;LINESIZE;LINK;LN;LNO;LOBOFFSET;LOCK;LOG;LONG;LONGCHUNKSIZE;LOOP;LOWER;LPAD;LTRIM;MAX;MAXEXTENTS;MIN;MINEXTENTS;MINUS;MINUTE;MLSLABEL;MOD;MODE;MODIFY;MONTH;MONTHS_BETWEEN;NATURAL;NATURALN;NEW;OLD;NEW_TIME;NEWPAGE;NEXT;NEXT_DAY;NEXTVAL;NOAUDIT;NOCOMPRESS;NOCOPY;NOT;NOWAIT;NULL;NUMBER;NUMBER_BASE;NUMFORMAT;NUMWIDTH;NVL;OCIROWID;OF;OFF;OFFLINE;ON;ONLINE;OPAQUE;OPEN;OPERATOR;OPTION;OR;ORDER;ORGANIZATION;OTHERS;OUT;PACKAGE;PAGESIZE;PARTITION;PAUSE;PCTFREE;PLS_INTEGER
Keyword6=PNO;POSITIVE;POSITIVEN;POWER;PRAGMA;PRIMARY;PRIOR;PRIVATE;PRIVATE;PRIVILEGES;PROCEDURE;PROFILE;PROMPT;PUBLIC;RAISE;RAISE_APPLICATION_ERROR;RANGE;RAW;RAWTOHEX;REAL;RECORD;RECSEP;RECSEPCHAR;REF;REFERENCES;RELEASE;REM;REMR;RENAME;REPFOOTER;REPHEADER;REPLACE;RESOURCE;RETURN;REVERSE;REVOKE;ROLE;ROLLBACK;ROUND;ROW;ROWID;ROWIDTOCHAR;ROWLABEL;ROWNUM;ROWS;ROWTYPE;RPAD;RTRIM;RUN;SAVEPOINT;SCHEMA;SECOND;SEGMENT;SELECT;SEPARATE;SEPERATE;SEQUENCE;SERVEROUTPUT;SESSION;SET;SHARE;SHIFTINOUT;SHOW;SHOWMODE;SIGN;SIN;SINH;SIZE;SMALLINT;SNAPSHOT;SOUNDEX;SPACE;SPOOL;SQL;SQLCASE;SQLCODE;SQLERRM;SQLNUMBER;SQLPROMPT;SQLTERMINATOR;SQRT;START
Keyword7=STATE;STATEMENT;STDDEV;STDDEV;SUBSTR;SUBTYPE;SUCCESSFUL;SUFFIX;SUM;SYNONYM;SYSDATE;SYSTEM;TAB;TABAUTH;TABLE;TABLES;TAN;TANH;TASK;TERMINATE;TERMOUT;THEN;TIME;TIMESTAMP;TIMING;TO;TO_CHAR;TO_DATE;TO_NUMBER;TRANSACTION;TRANSLATE;TRIGGER;TRIMOUT;TRIMSPOOL;TRUE;TRUNC;TTITLE;TYPE;UID;UNDERLINE;UNION;UNIQUE;UNLIMITED;UPDATE;UPPER;USE;USER;USERENV;USING;VALIDATE;VALUES;VARCHAR;VARCHAR2;VARIANCE;VERIFY;VIEW;VIEWS;VSIZE;WHEN;WHENEVER;WHERE;WHILE;WITH;WORK;WRAP;WRITE;XOR;YEAR;ZONE;CASCADE
Keyword8=FREELIST;FREELISTS;GROUPS;INITRANS;LOGGING;MAXTRANS;MAXVALUE;MINVALUE;NOCACHE;NOCYCLE;NOORDER;PCTINCREASE;REFERENCING;SQLERROR;STORAGE;TABLESPACE;TRIM;TRUNCATE;DISCONNECT;CYCLE;CONSTRAINTS;CONTINUE;CACHE;BUFFER_POOL;EXTEND;CURRENT_USER;ENABLE;DISABLE;RETURNING
Background=Default
Foreground=0000FF
bold=0

[Misc]
Type=keyword
Context=103
Scope=0
Priority=6
WholeWordOnly=1
Keyword1=||
Background=Default
Foreground=FF00FF
Bold=1

[Systemprocedures]
Type=keyword
Context=104
Scope=0
Priority=6
WholeWordOnly=1
Keyword1=ACCESSIBLE_COLUMNS;ACCESSIBLE_TABLES;ALL_CATALOG;ALL_CLUSTERS;ALL_CLUSTER_HASH_EXPRESSIONS;ALL_COL_COMMENTS;ALL_COL_PRIVS;ALL_COL_PRIVS_MADE;ALL_COL_PRIVS_RECD;ALL_CONSTRAINTS;ALL_CONS_COLUMNS;ALL_DB_LINKS;ALL_DEF_AUDIT_OPTS;ALL_DEPENDENCIES;ALL_ERRORS;ALL_HISTOGRAMS;ALL_INDEXES;ALL_IND_COLUMNS;ALL_OBJECTS;ALL_REFRESH;ALL_REFRESH_CHILDREN;ALL_SEQUENCES;ALL_SNAPSHOTS;ALL_SOURCE;ALL_SYNONYMS;ALL_TABLES;ALL_TAB_COLUMNS;ALL_TAB_COMMENTS;ALL_TAB_PRIVS;ALL_TAB_PRIVS_MADE;ALL_TAB_PRIVS_RECD;ALL_TRIGGERS;ALL_TRIGGER_COLS;ALL_UPDATABLE_COLUMNS;ALL_USERS;ALL_VIEWS;BROWSER_ALL_DOCS;BROWSER_DOCS;BROWSER_DOCS_GRANTED;BROWSER_DOCS_SQL;BROWSER_GRANTS;CATALOG;CODE_PIECES;CODE_SIZE;COL;COLUMN_PRIVILEGES;DBA_2PC_NEIGHBORS;DBA_2PC_PENDING;DBA_ANALYZE_OBJECTS;DBA_AUDIT_EXISTS;DBA_AUDIT_OBJECT;DBA_AUDIT_SESSION;DBA_AUDIT_STATEMENT;DBA_AUDIT_TRAIL;DBA_CATALOG;DBA_CLUSTERS;DBA_CLUSTER_HASH_EXPRESSIONS;DBA_CLU_COLUMNS;DBA_COL_COMMENTS;DBA_COL_PRIVS;DBA_CONSTRAINTS;DBA_CONS_COLUMNS;DBA_DATA_FILES;DBA_DB_LINKS;DBA_DEPENDENCIES;DBA_ERRORS;DBA_EXP_FILES;DBA_EXP_OBJECTS;DBA_EXP_VERSION;DBA_EXTENTS;DBA_FLASH_PROCS;DBA_FREE_EXTENT_SUM;DBA_FREE_SPACE;DBA_FREE_SPACE_COALESCED;DBA_FREE_SPACE_COALESCED_TMP1;DBA_FREE_SPACE_COALESCED_TMP2;DBA_HISTOGRAMS;DBA_INDEXES;DBA_INDEX_CHECKSUM;DBA_IND_COLUMNS;DBA_INTER_PROCS;DBA_JOBS;DBA_JOBS_RUNNING;DBA_OBJECTS;DBA_OBJECT_SIZE;DBA_OBJ_AUDIT_OPTS;DBA_PRIV_AUDIT_OPTS;DBA_PROFILES;DBA_RCHILD;DBA_REFRESH;DBA_REFRESH_CHILDREN;DBA_RGROUP;DBA_ROLES;DBA_ROLE_PRIVS;DBA_ROLLBACK_SEGS;DBA_SEGMENTS;DBA_SEQUENCES;DBA_SNAPSHOTS;DBA_SNAPSHOT_LOGS;DBA_SOURCE;DBA_STMT_AUDIT_OPTS;DBA_SYNONYMS;DBA_SYS_PRIVS;DBA_TABLES;DBA_TABLESPACES;DBA_TABLESPACE_SUM;DBA_TAB_COLUMNS;DBA_TAB_COMMENTS;DBA_TAB_PRIVS;DBA_TEMPSEGS;DBA_TRIGGERS;DBA_TRIGGER_COLS;DBA_TS_QUOTAS;DBA_UPDATABLE_COLUMNS;DBA_USERS;DBA_VIEWS;DEF$_TRAN;DEFCALL;DEFCALLDEST;DEFDEFAULTDEST;DEFERRCOUNT;DEFERROR;DEFSCHEDULE;DEFTRAN;DEFTRANDEST;DE_ATTACHED_LIBS;DICTIONARY;DICT_COLUMNS;DUAL;ERROR_SIZE;EXU7ANAL;EXU7AUD;EXU7BSZ;EXU7CCL;EXU7CCLO;EXU7CCLU;EXU7CCO;EXU7CCOU;EXU7CGR;EXU7CGRU;EXU7CLU;EXU7CLUC;EXU7CLUI;EXU7CLUU;EXU7COL;EXU7COLNN;EXU7COLU;EXU7COL_TEMP;EXU7CON;EXU7CONU;EXU7CPO;EXU7CSET;EXU7DEL;EXU7DELSNAP;EXU7DELSNAPL;EXU7DFR;EXU7ERC;EXU7FIL;EXU7FUL;EXU7GRN;EXU7GRNU;EXU7GRS;EXU7ICO;EXU7ICOU;EXU7IND;EXU7INDC;EXU7INDI;EXU7INDIC;EXU7INDU;EXU7JBQ;EXU7JBQU;EXU7LNK;EXU7LNKU;EXU7ORD;EXU7ORDU;EXU7PRF;EXU7PRR;EXU7PST;EXU7PSTC;EXU7PSTI;EXU7PSTIC;EXU7PSTU;EXU7REF;EXU7REFC;EXU7REFI;EXU7REFIC;EXU7REFU;EXU7RGC;EXU7RGCU;EXU7RGS;EXU7RGSU;EXU7RIF;EXU7RLG;EXU7ROL;EXU7RSG;EXU7SEQ;EXU7SEQU;EXU7SNAP;EXU7SNAPC;EXU7SNAPI;EXU7SNAPL;EXU7SNAPLC;EXU7SNAPLI;EXU7SNAPLU;EXU7SNAPU;EXU7SPR;EXU7SPRC;EXU7SPRI;EXU7SPS;EXU7SPSU;EXU7SPU;EXU7SPV;EXU7STO;EXU7STOU;EXU7SYN;EXU7SYNC;EXU7SYNI;EXU7SYNU;EXU7TAB;EXU7TABC;EXU7TABI;EXU7TABU;EXU7TBS;EXU7TGR;EXU7TGRC;EXU7TGRI;EXU7TGRIC;EXU7TGRU;EXU7TNE;EXU7TSQ;EXU7USCU;EXU7USR;EXU7USRU;EXU7VER;EXU7VEW;EXU7VEWC;EXU7VEWI;EXU7VEWU;FORM_APP;FORM_AUTHUSER;FORM_BLK;FORM_COMMENT;FORM_FLD;FORM_MAP;FORM_PAGE;FORM_PROCEDURE;FORM_REFERENCE;FORM_SQLTXT;FORM_TRG;FORM_TRIGGER;FORM_USER;FRM50_ENABLED_ROLES;GC_CHARTING;GC_FIELD;GC_REFERENCE;GLOBAL_NAME;GLOGIN_V;GO_COLUMN;GO_DOCUMENT;GO_PARAMETER;GO_QUERY;GO_SOUND;GO_TIMER;GO_VISLAYER;IMP7UEC;INDEX_HISTOGRAM;INDEX_STATS;LOADER_COL_INFO;LOADER_CONSTRAINT_INFO;LOADER_FILE_TS;LOADER_INDCOL_INFO;LOADER_IND_INFO;LOADER_PARAM_INFO;LOADER_TAB_INFO;LOADER_TRIGGER_INFO;NLS_DATABASE_PARAMETERS;NLS_INSTANCE_PARAMETERS;NLS_SESSION_PARAMETERS;ORA_KGLR7_DB_LINKS;ORA_KGLR7_DEPENDENCIES;ORA_KGLR7_IDL_CHAR;ORA_KGLR7_IDL_SB4;ORA_KGLR7_IDL_UB1;ORA_KGLR7_IDL_UB2;ORA_KGLR7_OBJECTS;ORDER_OBJECT_BY_DEPENDENCY;PARSED_PIECES;PARSED_SIZE;PLAN_VIEW;PRODUCT_COMPONENT_VERSION;PRODUCT_PRIVS;PS1$;PSS1$;PUBLICSYN;PUBLIC_DEPENDENCY;RESOURCE_COST;RES_EMP_INITS_V;ROLE_ROLE_PRIVS;ROLE_SYS_PRIVS;ROLE_TAB_PRIVS;ROSATTRIBS;ROSSTRUCTS;SESSION_PRIVS;SESSION_ROLES;SM$AUDIT_CONFIG;SM$INTEGRITY_CONS;SM$TS_AVAIL;SM$TS_FREE;SM$TS_USED;SM_$VERSION;SOURCE_SIZE;SRW2_ANCHOR;SRW2_BODY_LOCATION;SRW2_BOILERPLATE;SRW2_BUTTON;SRW2_COLUMN;SRW2_DATA_MODEL;SRW2_DISPLAY_TAG;SRW2_ELEMENT;SRW2_FIELD;SRW2_FORMAT_EXCEPTION;SRW2_FRAME;SRW2_GROUP;SRW2_GROUP_NODE;SRW2_HYPERLINK;SRW2_JAVA_APPLET;SRW2_JAVA_PROPERTIES;SRW2_LAYOUT;SRW2_LAYOUT_GROUP;SRW2_LINK;SRW2_LISTS;SRW2_MATRIX;SRW2_MODULE;SRW2_OGD_COLUMN_MAP;SRW2_OG_DOCUMENT;SRW2_PARAM_FORM;SRW2_QUERY;SRW2_TEXT_SEGMENT;SS_USERS_WITH_OBJECTS;SYNONYMS;SYSCATALOG;SYSCATALOG_;SYSFILES;SYSSEGOBJ;SYS_OBJECTS;TAB;TABLE_PRIVILEGES;TABQUOTAS;TOOL_ACCESS;TOOL_ACCESSIBLE;TOOL_COMMENT;TOOL_DEPEND;TOOL_DEPENDENT;TOOL_LIBRARY;TOOL_LRAW;TOOL_LTEXT;TOOL_MODULE;TOOL_PLSQL;USER_ARGUMENTS;USER_AUDIT_OBJECT;USER_AUDIT_SESSION;USER_AUDIT_STATEMENT;USER_AUDIT_TRAIL;USER_CATALOG;USER_CLUSTERS;USER_CLUSTER_HASH_EXPRESSIONS;USER_CLU_COLUMNS;USER_COL_COMMENTS;USER_COL_PRIVS;USER_COL_PRIVS_MADE;USER_COL_PRIVS_RECD;USER_CONSTRAINTS;USER_CONS_COLUMNS;USER_DB_LINKS;USER_DEPENDENCIES;USER_ERRORS;USER_EXTENTS;USER_FREE_SPACE;USER_HISTOGRAMS;USER_INDEXES;USER_INDEX_CHECKSUM;USER_IND_COLUMNS;USER_JOBS;USER_OBJECTS;USER_OBJECT_SIZE;USER_OBJ_AUDIT_OPTS;USER_PRIVS;USER_REFRESH;USER_REFRESH_CHILDREN;USER_RESOURCE_LIMITS;USER_ROLE_PRIVS;USER_SEGMENTS;USER_SEQUENCES;USER_SNAPSHOTS;USER_SNAPSHOT_LOGS;USER_SOURCE;USER_SYNONYMS;USER_SYS_PRIVS;USER_TABLES;USER_TABLESPACES;USER_TAB_COLUMNS;USER_TAB_COMMENTS;USER_TAB_PRIVS;USER_TAB_PRIVS_MADE;USER_TAB_PRIVS_RECD;USER_TRIGGERS;USER_TRIGGER_COLS;USER_TS_QUOTAS;USER_UPDATABLE_COLUMNS;USER_USERS;USER_VIEWS;VG_COLOR;VG_DRAWING;VG_FONT;VG_IMAGE;V_$ACCESS;V_$ACTIVE_INSTANCES;V_$ARCHIVE;V_$BACKUP;V_$BGPROCESS;V_$CIRCUIT;V_$COMPATIBILITY;V_$COMPATSEG;V_$CONTROLFILE;V_$DATABASE;V_$DATAFILE;V_$DBFILE;V_$DBLINK;V_$DB_OBJECT_CACHE;V_$DB_PIPES;V_$DISPATCHER;V_$ENABLEDPRIVS;V_$EVENT_NAME;V_$EXECUTION;V_$FILESTAT;V_$FIXED_TABLE;V_$FIXED_VIEW_DEFINITION;V_$INDEXED_FIXED_COLUMN;V_$INSTANCE;V_$LATCH;V_$LATCHHOLDER;V_$LATCHNAME;V_$LATCH_CHILDREN;V_$LATCH_MISSES;V_$LATCH_PARENT;V_$LIBRARYCACHE;V_$LICENSE;V_$LOADCSTAT;V_$LOADTSTAT;V_$LOCK;V_$LOCKED_OBJECT;V_$LOG;V_$LOGFILE;V_$LOGHIST;V_$LOG_HISTORY;V_$MLS_PARAMETERS;V_$MTS;V_$MYSTAT;V_$NLS_PARAMETERS;V_$NLS_VALID_VALUES;V_$OBJECT_DEPENDENCY;V_$OPEN_CURSOR;V_$OPTION;V_$PARAMETER;V_$PQ_SESSTAT;V_$PQ_SLAVE;V_$PQ_SYSSTAT;V_$PQ_TQSTAT;V_$PROCESS;V_$PWFILE_USERS;V_$QUEUE;V_$RECOVERY_FILE_STATUS;V_$RECOVERY_LOG;V_$RECOVERY_STATUS;V_$RECOVER_FILE;V_$REQDIST;V_$RESOURCE;V_$ROLLNAME;V_$ROLLSTAT;V_$ROWCACHE;V_$SESSION;V_$SESSION_CONNECT_INFO;V_$SESSION_CURSOR_CACHE;V_$SESSION_EVENT;V_$SESSION_WAIT;V_$SESSTAT;V_$SESS_IO;V_$SGA;V_$SGASTAT;V_$SHARED_POOL_RESERVED;V_$SHARED_SERVER;V_$SORT_SEGMENT;V_$SQL;V_$SQLAREA;V_$SQLTEXT;V_$SQLTEXT_WITH_NEWLINES;V_$SQL_BIND_DATA;V_$SQL_BIND_METADATA;V_$SQL_CURSOR;V_$SQL_SHARED_MEMORY;V_$STATNAME;V_$SYSSTAT;V_$SYSTEM_CURSOR_CACHE;V_$SYSTEM_EVENT;V_$SYSTEM_PARAMETER;V_$THREAD;V_$TIMER;V_$TRANSACTION;V_$TYPE_SIZE;V_$VERSION;V_$WAITSTAT;V_$_LOCK;X$KDXST_V;DICT;DICT_COLUMNS;CAT;OBJ;TABS;COLS;SYN;SEQ;IND;CLU
Background=Default
Foreground=800000