oraclesql.txt

UltraEdit中几百种语法高亮度显示

/L20"Oracle SQL" Nocase Line Comment = -- Block Comment On = /* Block 
Comment Off = */
/Block Comment On Alt = doc  Block Comment Off Alt = #
/String Chars = ' File Extensions = SQL PLS PLB PKS PKB
/Delimiters = .~!%@^&*()-+=|\/{}[]:;"'<> ,    ?
/Indent Strings = "BEGIN THEN select from where group order" "("
/Unindent Strings = "END END-IF from where group order" ")"
/Function String = "%*function ^(*^) "
/Function String 1 = "%*procedure ^(*^) "
/Function String 2 = "%*trigger ^(*^)^p"

/C1 "SQL keywords"
(
)
alter analyze
backup begin
commit create case copy
database declare delete drop DUAL
else end exec execute exit explain
exp
fetch from for
group
having
if insert intersect into
imp
join
load
minus
of off on open order outer
prepare proc procedure
read restrict return rollback
save select shutdown startup
sqlldr sqlplus
table then truncate
union update
view
when where while


/C2 "SQL Functions"
** stddev regr
ABS ACOS ADD_MONTHS ASCII ASIN ATAN ATAN2 AVG AVERAGE
BFILENAME BLOB BFILE
BFILE_TABLE BINARY_INTEGER BLOB_TABLE BOOLEAN
binary bit
cast char character count ceil chr
CHARRARR CLOB_TABLE
CHARTOROWID CONCAT COS COSH cube
compute covar_samp covar_pop
cume_dist current_row clob
date datetime dec decimal decode dense_rank
DATE_TABLE DBLINK_ARRAY DESC_REC DESC_TAB
DEREF
EMPTY_BLOB EMPTY_CLOB
EMPTY ERROR
estimate
FILE_TYPE
first first_value float floor following
greatest grouping
HEXTORAW
image int integer instr
INDEX_TABLE_TYPE
INITCAP INSTRB ISOPEN
last LAST_DAY LENGTHB LN LOG LOWER LENGHT LUB
last_value lead lag least length ltrim lpad
LONG
MAKE_REF MOD MONTHS_BETWEEN
MAXWAIT
money max min
multiset
NAME_ARRAY NATIVE NUMBER_ARRAY NUMBER_TABLE NCLOB_TABLE nulls
nchar ntext numeric nvarchar nvl number nlssort nvarchar2
NEW_TIME NEXT_DAY NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME 
NLS_INITCAP NLS_LOWER NLS_SORT NLS_UPPER NVL
ntile nclob
percent_rank
PLS_INTEGER pls_int
POWER
preceding
rank
ratio_to_report rollup
RAW REFCURSOR
RAWTOHEX REFTOHEX ROWIDTOCHAR
real round rtrim replace rpad
RECORD
REG_REPAPI_SNAPSHOT REG_UNKNOWN REG_V7_SNAPSHOT REG_V8_SNAPSHOT
RNDS RNPS
row_number
SIN SINH SOUNDEX SUBSTRB string
smalldatetime smallint smallmoney sqrt sum sign substr SIGNTYPE
TAN TANH TO_LABEL TO_MULTI_BYTE TO_SINGLE_BYTE to_lob
text timestamp tinyint to_char to_number trim translate trunc to_date
UID USERENV USING UNBOUNDED
UNCL_ARRAY urowid
uniqueidentifier upper
V6 V7 VARCHAR2 VARCHAR2S VARCHAR2_TABLE
varbinary varchar varray var_samp var_pop
VARIANCE VSIZE
WNDS WNPS
XOR


/C3 "Exceptions"
add_ all_ allocate_ allow_ ACCESS_INTO_NULL
column_ create_ COLLECTION_IS_NULL CURSOR_ALREADY_OPEN
dba_ dbms_ drop_ DEQUEUE DUP_VAL_ON_INDEX
ENQUEUE ERASE
file
index_ invalid_ INCONSISTENT_TYPE INTERNAL_ERROR
job_
load_ LOGIN_DENIED
message_
nls_ NOT_LOGGED_ON NO_DATA_FOUND
OTHERS
PROGRAM_ERROR
queue_
receive_ remove_ role_ READ_ERROR REQUEST
session_ SCHEDULE STORAGE_ERROR SUBSCRIPT_BEYOND_COUNT SUBSCRIPT_OUTSIDE_LIMIT SYS SYS.
table_ TIMEOUT_ON_RESOURCE TOO_MANY_ROWS
user_ UNKEEP UNSCHEDULE_
verify V$ VALUE_ERROR V_$
ZERO_DIVIDE

/C4 "SqlPlus"
#
app append accept
appi auto autop autot ali alias
appinfo arraysize autocommit autoprint autotrace autorecovery
blo
blockterminator break breaks btitle bre
bti
btitile buff buffsize
cmds com con copyc cou
cmdsep col column clear colsep compatibility copycommit copytypecheck
conn cre comp
depth describe define dup def doc      #
disc duplicates
echo editfile embedded entmap
editf emb esc
feed format feedback flagger fold_a fold_b
flu
get
hea heads
head heading host headsep html
help ho
indent invisible
internal
jus
lin lobof longc
linenum lines linesize left lno loboffset logsource longchunksize
lis
markup
newp numf num
newpage new_value noprint numwidth numformat
nol nolist new_v nodup noduplicates
old_v old_value
page print pages pagesize prompt pause pno pref preformat parameter
passw pri pro
pau
recsep recsepchar report repfooter repheader
rem remark rep reph repf
sav spo sho
serverout skip serveroutput shiftinout show showmode spool
shift sqlbl sqlc sqlc sqln sqlpre sqlp sqlt suf
spoo
sqlblanklines sqlcase sqlcontinue sqlnumber sqlpluscompatibility 
sqlprefix sqlprompt sqlterminator suffix
tab timing trimout trims termout trimspool tti ttitle
term ti timi
trace tru truncated
und
undef underline
undefine
ver value version var variable
WHENEVER word wrap wrapped word_wrapped
wra wor

/C5 "sql bits"
add all and any as asc authorization
browse bulk by between build
call collect
cascade check checkpoint close clustered coalesce committed confirm 
constraint contains containstable continue controlrow convert cross 
current current_date current_time current_timestamp current_user cursor
dbcc deallocate default deny desc disk distinct distributed double 
dummy dump disconnect
except exists errlvl errorexit escape exchange extend
fillfactor floppy foreign freetext freetexttable full
go goto grant global
holdlock heap
identity identity_insert identitycol in index inner is isolation
INSERTING invalidate indextype
key kill
level like lineno logon logoff limit
mirrorexit move merge materialized
national nocheck nonclustered nullif not null novalidate
offsets once only opendatasource openquery openrowset option or over 
organization
percent perm permanent pipe plan precision primary privileges 
processexit public
raiserror readtext reconfigure references repeatable replication 
restore revoke right rowcount rowguidcol rule resolver
returning
session schema serializable session_user set setuser some statistics 
structure scope split servererror store scan
tape temp temporary textsize to top tran transaction trigger tsequal
uncommitted unique updatetext use user
updating
values varying validate
waitfor with work writetext


/C6 "PLSQL-Functions"
ABORT ARRAY ARRAYLEN ASSERT ASSIGN AT activate authenticated
ACCESS ADMIN AFTER ALLOCATE ARCHIVE ARCHIVELOG AUDIT autoextend ancillary
account authid attribute attributes autoallocate automatic 
autonomous_transaction
BASE_TABLE BODY binding
BECOME BEFORE BLOCK
buffer_pool blocksize
CACHE CANCEL CHANGE CLUSTER COBOL COMMENT COMPILE COMPRESS CONNECT 
CONNECTED CONSTRAINTS CONTENTS CONTROLFILE CYCLE
calling category charsetform charsetid class
CHAR_BASE CLUSTERS COLAUTH COLUMNS CONSTANT CRASH CURRVAL
child clone cost complete consistent chained context
DATAFILE DISABLE DISMOUNT deferrable dangling descriptor
DATA_BASE DBA DEBUGOFF DEBUGON DEFINITION DELAY DELTA DIGITS DISPOSE 
DO  data
definer demand determines deterministic dictionary degree deferred 
debug dimension
EACH ENABLE ERRORS EVENTS EXCEPTIONS EXCLUSIVE EXTENT EXTERNALLY
ELSIF ENTRY EXCEPTION EXCEPTION_INIT
expire excluding
external
FALSE FORM FUNCTION forward fast
FLUSH FORCE FORTRAN FOUND FREELIST FREELISTS
GENERIC GROUPS
hash hashkeys
hierachy
IDENTIFIED IMMEDIATE INCLUDING INCREMENT INITIAL INITRANS INSTANCE
INDEXES INDICATOR INTERFACE instances initially instead indexed 
include input
java
keep
LANGUAGE LAYER LINK LISTS LOCK LOGFILE LIMITED LOOP
local list lob library
logging less
MANAGE MANUAL MAXDATAFILES MAXEXTENTS MAXINSTANCES MAXLOGFILES 
MAXLOGHISTORY MAXLOGMEMBERS
managed member management monitoring minimize master map maxlen 
maxsize minimum
MAXTRANS MAXVALUE MINEXTENTS MINVALUE MLSLABEL MODE MODIFY MODULE 
MOUNT MISLABEL
NATURAL NATURALN NEW NEXTVAL NUMBER_BASE
never nocopy named NEW_LINE
NEXT NOARCHIVELOG NOAUDIT NOCACHE NOCOMPRESS NOCYCLE NOLOGGING 
NOMAXVALUE NOMINVALUE NONE NOORDER NORESETLOGS NORMAL NOSORT  
NOTFOUND NOWAIT 
noparallel nomonitoring nominimize noforce
OFFLINE ONLINE OPTIMAL OWN overflow outline operator
OLD OUT object oracle output
PACKAGE PARTITION PARTITIONs POSITIVE POSITIVEN PRAGMA PRIVATE
PARALLEL PCTFREE PCTINCREASE PCTUSED PLI PRIOR PROFILE parent 
pctthreshold parameters
parallel_enable
password
prebuilt pascal
query
QUOTA
RAISE RANGE REF RELEASE REMR RESTRICT_REFERENCES REVERSE ROWTYPE RUN
rebuild
RECOVER REFERENCING RENAME RESETLOGS RESOURCE RESTRICTED REUSE ROLE 
ROLES ROW ROWID ROWLABEL ROWNUM ROWS
recycle recoverable
reduced
retry reset
rewrite resolve
SAVEPOINT SEPARATE SEPERATE SPACE SQL SQLCODE SQLERRM STATEMENT 
SUBTYPE shrink static self sample
SCN SECTION SEGMENT SEQUENCE SHARE SHARED SIZE SNAPSHOT SORT SQLBUF 
SQLERROR SQLSTATE START STATEMENT_ID STOP STORAGE SUCCESSFUL SWITCH 
SYNONYM SYSDATE SYSTEM
serially_reusable standard source
standby shared_pool subpartition subpartitions
TABAUTH TABLES TASK TERMINATE TRUE TYPE
TABLESPACE THREAD TIME TRACING TRIGGERS
timeout than
transactional tempfile
UNDER UNTIL unlimited unused uniform unarchived unrecoverable unlock 
unusable
VIEWS
without
WRITE


/C7 "sp functions"
** xp_ is_ sp_ spt_ utl_ put_ set_ read_ write_ rowid_
forall

/C8 "Package Methods"
** ALTER_ ANALYZE_ BIND_ DEFINE_ LAST_ NAME_ NEXT_ VALIABLE_ GET_ 
VARIABLE_
BEGIN_TABLE_REORGANISATION
CHECK_PRIVS CLOSE_CURSOR
COMMA_TO_TABLE COMMIT_CM COMPILE_SCHEMA CREATE_PIPE
DATA_BLOCK_ADDRESS_FILE DB_VERSION
DELETING DESCRIBE_COLUMNS DESCRIBE_PROCEDURE
END_TABLE_REORGANISATION EXECUTE_AND_FETCH EXEC_DDL_STATEMENT
FCLOSE FCLOSE_ALL FETCH_ROWS FFLUSH FOPEN FORMAT_CALL_STACK 
FORMAT_ERROR_STACK
INTERVAL ISUBMIT I_AM_A_REFRESH
MAKE_DATA_BLOCK_ADDRESS
OPEN_CURSOR
PACK_MESSAGE PARSE PORT_STRING PURGE PURGE_LOG PURGE_SNAPSHOT_FROM_LOG 
PUT PUTF
preserve
RAISE_APPLICATION_ERROR RECEIVE_MESSAGE REFRESH REFRESH_ALL REGISTER 
REGISTER_SNAPSHOT
REMOVE REMOVE_ALL REMOVE_PIPE RESET_BUFFER ROLLBACK_NR ROLLBACK_SV
SEND_MESSAGE SET_DEFAULTS SET_I_AM_A_REFRESH SET_TRANSACTION_USE 
SIGNAL SUBMIT
TABLE_TO_COMMA
UNIQUE_SESSION_NAME UNPACK_MESSAGE UNREGISTER_SNAPSHOT
WAITANY WAITONE WHAT

/C9 "delimiters"
!
!=
%
+
-
// /
< <= <>
<=
=

 >=
 =

[
]
|