: $Id: sql.key,v 1.13 2009/11/12 09:53:41 tom Exp $
: Keywords for SQL - all of the ANSI ones for which I can deduce their context,
: and most Oracle 7 keywords, plus many Oracle 10 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
truncate
update
:
: PL/SQL (verbs and control flow)
begin
close
declare
else
elsif
end
exit
fetch
goto
if
loop
pragma
raise
then
while
:
.default Keyword2
constant
exception
record:Type
statement
type
:
: Cursor attributes
.default Keyword2
%found
%isopen
%notfound
%rowcount
%rowtype
%type
:
: Other keywords
.default Keyword2
access
add
after
allocate
as
asc
before
body
buffer_pool
build
by
cache
cascade
check
cluster
column
complete
compress
connect
constraint
constraints
current
cycle
database
datafile
decimal
default
desc
each
exclusive
extent
fast
file
for
force
freelist
freelists
from
function
group
groups
having
identified
immediate
increment
index
initial
initrans
instead
into
is
level
link
log
logging
materialized
maxextents
maxtrans
maxvalue
minextents
minvalue
mode
modify
new
next
nocache
nocompress
nocycle
noforce
nologging
nominvalue
noorder
nowait
of
offline
old
on
online
optimal
option
order
package
pctfree
pctincrease
pctused
permanent
primary
privileges
procedure
public
queue
referencing
refresh
resource
restricted
return
reuse
row
rowlabel
rownum
rows
sequence
session
share
size
smallint
start
storage
successful
synonym
table
tablespace
temporary
to
transaction
trigger
triggers
uid
unique
unrestricted
usage
user
using
validate
values
view
when
whenever
where
with
:
: Operators and Functions
.default Ident2
all
and
any
ascii
avg
between
ceil
chartorowid
chr
decode
distinct
escape
exists
floor
greatest
hextoraw
in
initcap
instr
instrb
intersect
least
length
like
lower
lpad
ltrim
max
min
minus
not
nvl
or
prior
rawtohex
replace
rowidtochar
rpad
rtrim
some
substr
substrb
sysdate
to_binary_integer
to_char
to_date
to_number
to_varchar2
translate
trunc
union
upper
userenv
:
: Types
.default Type
blob
boolean
char
character
date
dec
decimal
float
int
integer
long
mlslabel
number
raw
rowid
smallint
varchar2
varchar
:
: SQL*PLUS (Oracle 10)
:
: Put a "1" (one) flag after symbols in SQL*Plus which must complete on one
: line.  Otherwise, the parser will allow continuation lines.
.table sqlplus
.default Action
acc?ept::1
a?ppend
archive
log:Ident2
attribute
bre?ak
bti?tle
c?hange
cl?ear
col?umn::1
comp?ute
conn?ect
copy
def?ine
del
desc?ribe
disc?onnect
ed?it
exec?ute
exit
get
help
ho?st
input
l?ist
passw?ord
pau?se
pri?nt
pro?mpt::1
quit
recover
rem?ark:Comment:1
repf?ooter
reph?eader
r?un
sav?e
set::1
sho?w
shutdown
spo?ol::1
sta?rt
startup
store
timi?ng
ttitle
undef?ine
var?iable
whenever
oserror:Ident2
whenever
sqlerror:Ident2
