: $Id: sql.key,v 1.7 2002/02/11 21:25:48 tom Exp $ : Keywords for SQL - all of the ANSI ones for which I can deduce their context, : and most Oracle 7 keywords. : rem:Comment remark:Comment : null:Keyword2 sqlcode:Ident sqlerrm:Ident sqlerror:Ident : : Statements alter analyze audit comment commit count create cursor delete describe disable drop enable explain grant insert lock noaudit open rename revoke rollback savepoint segment select set truncate update : : PL/SQL (verbs and control flow) begin close declare else elseif end exit fetch goto if loop pragma raise then while : constant:Keyword2 exception:Keyword2 record:Type statement:Keyword2 type:Keyword2 : : Actions: connect:Action disconnect:Action shutdown:Action prompt:Action spool:Action startup:Action : : Cursor attributes %found:Keyword2 %isopen:Keyword2 %notfound:Keyword2 %rowcount:Keyword2 %rowtype:Keyword2 %type:Keyword2 : : Other keywords access:Keyword2 add:Keyword2 after:Keyword2 allocate:Keyword2 as:Keyword2 asc:Keyword2 before:Keyword2 body:Keyword2 buffer_pool:Keyword2 by:Keyword2 cache:Keyword2 cascade:Keyword2 check:Keyword2 cluster:Keyword2 column:Keyword2 compress:Keyword2 constraint:Keyword2 constraints:Keyword2 current:Keyword2 cycle:Keyword2 database:Keyword2 datafile:Keyword2 decimal:Keyword2 default:Keyword2 desc:Keyword2 each:Keyword2 exclusive:Keyword2 extent:Keyword2 file:Keyword2 for:Keyword2 force:Keyword2 freelist:Keyword2 freelists:Keyword2 from:Keyword2 function:Keyword2 group:Keyword2 groups:Keyword2 having:Keyword2 identified:Keyword2 immediate:Keyword2 increment:Keyword2 index:Keyword2 initial:Keyword2 initrans:Keyword2 into:Keyword2 is:Keyword2 level:Keyword2 logging:Keyword2 maxextents:Keyword2 maxtrans:Keyword2 maxvalue:Keyword2 minextents:Keyword2 minvalue:Keyword2 mode:Keyword2 modify:Keyword2 next:Keyword2 nocache:Keyword2 nocompress:Keyword2 nocycle:Keyword2 noforce:Keyword2 nologging:Keyword2 nominvalue:Keyword2 noorder:Keyword2 nowait:Keyword2 of:Keyword2 offline:Keyword2 on:Keyword2 online:Keyword2 optimal:Keyword2 option:Keyword2 order:Keyword2 package:Keyword2 pctfree:Keyword2 pctincrease:Keyword2 pctused:Keyword2 permanent:Keyword2 primary:Keyword2 privileges:Keyword2 procedure:Keyword2 public:Keyword2 queue:Keyword2 referencing:Keyword2 resource:Keyword2 return:Keyword2 reuse:Keyword2 row:Keyword2 rowlabel:Keyword2 rownum:Keyword2 rows:Keyword2 sequence:Keyword2 session:Keyword2 set:Keyword2 share:Keyword2 size:Keyword2 smallint:Keyword2 start:Keyword2 storage:Keyword2 successful:Keyword2 synonym:Keyword2 table:Keyword2 tablespace:Keyword2 temporary:Keyword2 to:Keyword2 transaction:Keyword2 trigger:Keyword2 triggers:Keyword2 uid:Keyword2 unique:Keyword2 usage:Keyword2 user:Keyword2 using:Keyword2 validate:Keyword2 values:Keyword2 view:Keyword2 when:Keyword2 whenever:Keyword2 where:Keyword2 with:Keyword2 : : Operators and Functions all:Ident2 and:Ident2 any:Ident2 ascii:Ident2 avg:Ident2 between:Ident2 ceil:Ident2 chartorowid:Ident2 chr:Ident2 decode:Ident2 distinct:Ident2 escape:Ident2 exists:Ident2 floor:Ident2 greatest:Ident2 hextoraw:Ident2 in:Ident2 initcap:Ident2 instr:Ident2 instrb:Ident2 intersect:Ident2 least:Ident2 length:Ident2 like:Ident2 lower:Ident2 lpad:Ident2 ltrim:Ident2 max:Ident2 min:Ident2 minus:Ident2 not:Ident2 nvl:Ident2 or:Ident2 prior:Ident2 rawtohex:Ident2 replace:Ident2 rowidtochar:Ident2 rpad:Ident2 rtrim:Ident2 some:Ident2 substr:Ident2 substrb:Ident2 sysdate:Ident2 to_binary_integer:Ident2 to_char:Ident2 to_date:Ident2 to_number:Ident2 to_varchar2:Ident2 translate:Ident2 trunc:Ident2 union:Ident2 upper:Ident2 userenv:Ident2 : : Types blob:Type boolean:Type char:Type character:Type date:Type dec:Type decimal:Type float:Type int:Type integer:Type long:Type mlslabel:Type number:Type raw:Type rowid:Type smallint:Type varchar2:Type varchar:Type