BBEditDocumentType CodelessLanguageModule BBLMColorsSyntax BBLMIsCaseSensitive BBLMKeywordList ABORT ABS ACCESS ACCESSED ACCOUNT ACOS ACTIVATE AD ADD ADD_MONTHS ADMIN ADMINISTER ADVISE AFTER AGENT ALL ALL_ROWS ALLOCATE ALLOW ALTER ANALYZE ANCILLARY AND AND_EQUAL ANSI ANY APPEND APPLY AQ_ADMINISTRATOR_ROLE AQ_USER_ROLE ARCHIVE ARCHIVELOG AS ASC ASCII ASCIISTR ASIN ASSOCIATE ATAN ATTRIBUTE ATTRIBUTES AUDIT AUTHENTICATED AUTHID AUTOALLOCATE AUTOEXTEND AUTOMATIC AVG BACKUP BECOME BEFORE BEGIN BETWEEN BFILE BFILENAME BIN_TO_NUM BINDING BITAND BITMAP BLOB BLOCK BLOCKSIZE BODY BUILD BY BYTE CACHE CALL CANCEL CASCADE CASE CAST CATEGORY CATSEARCH CEIL CHAINED CHANGE CHAR CHARACTER CHARTOROWID CHECK CHECKPOINT CHOOSE CHR CHUNK CIRCUITS CLASS CLEAR CLOB CLOSE CLUSTER COALESCE COLUMN COLUMNS COMMENT COMMIT COMPATIBILITY COMPATIBLE COMPILE COMPLETE COMPOSE COMPRESS COMPUTE CONCAT CONNECT CONSIDER CONSTRAINT CONSTRAINTS CONTAINS Contents CONTEXT CONTINUE CONTROLFILE CONVERT CORR CORRUPTION COS COSH COST COUNT COVAR_POP COVAR_SAMP CREATE CUBE CUME_DIST CURRENT CURRENT_DATE CURRENT_TIMESTAMP CURRENT_USER CURRRENT_DATE CURRRENT_TIMESTAMP CURRVAL CURSOR CYCLE DANGLING DATA DATABASE DATAFILE DATAFILES DATE DAY DBA DBMS_OUTPUT DBMS_ROWID DBTIMEZONE DEALLOCATE DEBUG DECIMAL DECODE DECOMPOSE DEFAULT DEFERRABLE DEFERRED DEFINER DELETE DELETE_CATALOG_ROLE DEMAND DENSE_RANK DEREF DESC DETERMINISTIC DICTIONARY DIMENSION DIRECTORY DISABLE DISASSOCIATE DISCONNECT DISPATCHERS DISTINCT DISTRIBUTED DML DOUBLE DRIVING_SITE DROP DUAL DUMP DYNAMIC_SAMPLING EACH ELSE EMPTY_BLOB EMPTY_CLOB ENABLE END ESTIMATE EVENTS EXCEPT EXCEPTIONS EXCHANGE EXCLUDING EXCLUSIVE EXECUTE EXECUTE_CATALOG_ROLE EXEMPT EXISTS EXISTSNODE EXP EXP_FULL_DATABASE EXPIRE EXPLAIN EXTENT EXTERNAL EXTERNALLY EXTRACT EXTRACTVALUE EXTRACTXML FAST FILE FINAL FIPS FIRST FIRST_ROWS FIRST_VALUE FLAGGER FLASHBACK FLOAT FLOOR FLUSH FM FOR FORCE FORCE_UNION_REWRITE FOREIGN FREELIST FREELISTS FREEPOOLS FRESH FROM FROM_TZ FULL FUNCTION FUNCTIONS FX GLOBAL GLOBALLY GRANT GRAPHIC GREATEST GROUP GROUP_ID GROUPING GROUPING_ID GROUPS GUARD HASH HASH_AJ HASHKEYS HAVING HEAP HEXTORAW HIERARCHY HS_ADMIN_ROLE ID IDENTIFIED IDENTIFIER IFILE IMMEDIATE IMP_FULL_DATABASE IN INCLUDING INCREMENT INDEX INDEX_ASC INDEX_DESC INDEXES INDEXTYPE INDEXTYPES INITCAP INITIAL INITIALIZED INITIALLY INITRANS INSERT INSTANCE INSTANTIABLE INSTEAD INSTR INSTRB INSTRC INT INTEGER INTERSECT INTERVAL INTO INVALIDATE IS ISO JAVA JOIN KEY KILL LAG LANGUAGE LAST LAST_DAY LAST_VALUE LEAD LEAST LENGTH LENGTHB LENGTHC LESS LEVEL LIBRARY LIKE LINK LIST LN LOB LOCAL LOCALTIMESTAMP LOCK LOG LOGFILE LOGGING LOGICAL LOGOFF LOGON LONG LOWER LPAD LTRIM MAKE_REF MANAGE MANAGED MANAGEMENT MAP MAPPING MATCHED MATCHES MATERIALIZED MAX MAXDATAFILES MAXEXTENTS MAXINSTANCES MAXLOGFILES MAXLOGHISTORY MAXLOGMEMBERS MAXSIZE MAXTRANS MAXVALUE MEMBER MERGE MERGE_AJ MIGRATE MIN MINEXTENTS MINIMIZE MINIMUM MINUS MINVALUE MLSLABEL MOD MODE MODIFY MONITORING MONTH MONTHS_BETWEEN MOUNT MOVE MOVEMENT MULTISET NAME NAMED NATIONAL NCHAR NCHR NCLOB NESTED NEW NEW_TIME NEXT NEXT_DAY NEXTVAL NL_SJ NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLS_UPPER NLSSORT NO NO_EXPAND NO_INDEX NO_MERGE NO_PUSH_PRED NO_PUSH_SUBQ NOAPPEND NOARCHIVELOG NOAUDIT NOCACHE NOCOMPRESS NOCOPY NOCYCLE NOFORCE NOLOGGING NOMAXVALUE NOMINIMIZE NOMINVALUE NOMONITORING NONE NOORDER NOPARALLEL NOPARALLEL_INDEX NORELY NORESETLOGS NOREVERSE NOREWRITE NOROWDEPENDENCIES NOSORT NOT NOVALIDATE NOWAIT NTILE NULL NULLIF NUMBER NUMER NUMERIC Numerics NUMTODSINTERVAL NUMTOYMINTERVAL NVL OBJECT OF OFFLINE OIDINDEX ON ONLINE ONLY OPEN OPERATOR OPTIMAL OPTION OR ORDER ORDERED ORDERED_PREDICATES ORGANIZATION OUT OUTLINE OVER OVERFLOW OVERRIDING PACKAGE PACKAGES PAGETABLE PARALLEL PARALLEL_ENABLE PARAMETERS PARTITION PARTITIONS PASSWORD PATH_VIEW PCT_ACCESS_DIRECT PCTFREE PCTINCREASE PCTTHRESHOLD PCTUSED PCTVERSION PER PERCENT_CONT PERCENT_DISC PERCENT_RANK PERCENTILE_CONT PERCENTILE_DISC PERMANENT PFILE PIPELINED PLAN PLAN_TABLE PLSQL_DEBUG POLICY POOL POWER PQ_DISTRIBUTE PRAGMA PREBUILT PRECISION PRIMARY PRIOR PRIVATE PRIVILEGE PRIVILEGES PROCEDURE PROCESSES PROFILE PUBLIC PUSH_PRED PUSH_SUBQ QUERY QUIESCE QUOTA RANGE RANK RATIO_TO_REPORT RAW RAWTOHEX RAWTONHEX READ READS REAL REBUILD RECORDS RECOVER RECOVERABLE RECOVERY RECOVERY_CATALOG_OWNER REF REFERENCES REFERENCING REFRESH REFTOHEX REGISTER REGR_AVGX REGR_AVGY REGR_COUNT REGR_INTERCEPT REGR_R2 REGR_SLOPE REGR_SXX REGR_SXY REGR_SYY RELY RENAME REPLACE RESET RESETLOGS RESIZE RESOLVE RESOLVER RESOURCE RESOURCE_VIEW RESTRICT_REFERENCES RESTRICTED RESUMABLE RESUME RETENTION RETURN RETURNING REUSE REVERSE REVOKE REWRITE RNDS RNPS ROLE ROLLBACK ROLLUP ROUND ROW ROW_NUMBER ROWDEPENDENCIES ROWID ROWIDTOCHAR ROWIDTONCHAR ROWNUM ROWS RPAD RTRIM RULE SAMPLE SAVEPOINT SCHEMA SCOPE SCORE SECOND SEGMENT SEGMENTS SELECT SELECT_CATALOG_ROLE SELECTIVITY SEQUENCE SERVERERROR SESSION SESSION_ROLES SESSIONS SESSIONTIMEZONE SET SETS SETTINGS SHARE SHARED SHRINK SHUTDOWN SIBLINGS SIGN SIN SINGLE SINH SIZE SMALLINT SNAPSHOT SNMPAGENT SOME SOUNDEX SOURCE SPECIFICATION SPFILE SPLIT SQL SQLJ SQRT STANDBY STAR_TRANSFORMATION START STARTUP STATIC STATISTICS STDDEV STDDEV_POP STDDEV_SAMP STOP STORAGE STORE STRUCTURE SUBPARTITION SUBSTR SUBSTRB SUBSTRC SUCCESSFUL SUM SUPPLEMENTAL SUSPEND SWITCH SWITCHOVER SYNONYM SYS SYS_CONNECT_BY_PATH SYS_CONTEXT SYS_DBURIGEN SYS_EXTRACT_UTC SYS_GUID SYS_NC_ROWINFO$ SYS_TYPEID SYS_XMLAGG SYS_XMLGEN SYSDATE SYSDBA SYSOPER SYSTEM SYSTIMESTAMP TABLE TABLES TABLESPACE TAN TANH TEMPFILE TEMPORARY TEST THAN THEN THREAD THROUGH TIME TIMESTAMP TO TO_CHAR TO_CLOB TO_DATE TO_DSINTERVAL TO_LOB TO_MULTI_BYTE TO_NCHAR TO_NCLOB TO_NUMBER TO_SINGLE_BYTE TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL TRANSACTION TRANSACTIONS TRANSLATE TREAT TRIGGER TRIGGERS TRIM TRUNC TRUNCATE TRUST TYPE TYPES TZ_OFFSET UID UNDER UNDER_PATH UNDO UNIFORM UNION UNIQUE UNISTR UNLIMITED UNLOCK UNQUIESCE UNRECOVERABLE UNUSABLE UNUSED UPDATE UPDATEXML UPGRADE UPPER UROWID USAGE USE_CONCAT USE_MERGE USE_NL USER USERENV USING UTC VALIDATE VALUE VALUES VAR_POP VAR_SAMP VARCHAR VARCHAR2 VARGRAPHIC VARIANCE VARRAY VARYING VEIW VIEW VSIZE WHEN WHENEVER WHERE WIDTH_BUCKET WITH WNDS WNPS WRITE XML XMLDATA YEAR ZONE ACCESS_INTO_NULL AUTONOMOUS_TRANSACTION BINARY_INTEGER BOOLEAN BULK CASE_NOT_FOUND COLLECT COLLECTION_IS_NULL CURSOR_ALREADY_OPEN DECLARE DBMS_ALERT DBMS_PIPE DEC DUP_VAL_ON_INDEX ELSIF EXCEPTION EXCEPTION_INIT EXIT EXTEND FALSE FETCH FORALL GOTO IF INVALID_CURSOR INVALID_NUMBER LIMIT LOGIN_DENIED LOOP NATURAL NATURALN NO_DATA_FOUND NOT_LOGGED_ON NVARCHAR2 OTHERS PIPE PLS_INTEGER PLSQL_V2_COMPATIBILITY POSITIVE POSITIVEN PROGRAM_ERROR RAISE RECORD REPEAT ROWTYPE_MISMATCH SELF SERIALLY_REUSABLE SIGNTYPE SQLCODE SQLERRM STEP STRING SUBSCRIPT_BEYOND_COUNT SUBSCRIPT_OUTSIDE_LIMIT SYS_REFCURSOR TIMEOUT_ON_RESOURCE TOO_MANY_ROWS TRUE UNTIL UTL_FILE UTL_HTTP VALUE_ERROR WHILE ZERO_DIVIDE BBLMLanguageCode OPSQ BBLMLanguageDisplayName Oracle SQL and PL/SQL BBLMScansFunctions BBLMSuffixMap BBLMLanguageSuffix .sql BBLMLanguageSuffix .plsql Language Features Identifier and Keyword Characters 0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz-_.$% Prefix for Functions FUNCTION Prefix for Procedures PROCEDURE Open Parameter Lists Close Parameter Lists Terminator for Prototypes 1 ; Terminator for Prototypes 2 Open Statement Blocks BEGIN Close Statement Blocks END; Open Block Comments Close Block Comments \n Open Line Comments -- Open Strings 1 ' Close Strings 1 ' Escape Char in Strings 1 End-of-line Ends Strings 1 Open Strings 2 Close Strings 2 End-of-line Ends Strings 2 Escape Char in Strings 2