今天发现了一个显示oracle语法的好网站。内容太多,就不一一摘录了,记在这里,也方便自己查找。
目录如下:
an a-z index of oracle sql commands (version 9.2)
analyze
audit
call
cluster – create cluster
– alter cluster
– drop cluster
comment
commit
connect
constraint – add / enable
context – create context
– drop context
controlfile – create controlfile
database – create database
– alter database
delete
describe
dimension – create dimension
– alter dimension
– drop dimension
directory – create directory
– drop directory
exec
execute immediate
explain plan
function – create function
– alter function
– drop function
grant
index – create index
– alter index
– drop index
indextype – create indextype
– drop indextype
insert
intersect
java – create java
– alter java
– drop java
library – create library
– drop library
link – create database link
– drop database link
lock table
mview – create materialized view
– alter materialized view
– drop materialized view
– create materialized view log
– alter materialized view log
– drop materialized view log
minus
noaudit
operator – create operator
– drop operator
outline – create outline
– alter outline
– drop outline
package – create package/body
– alter package
– drop package
pfile – create pfile
procedure – create procedure
– alter procedure
– drop procedure
profile – create profile
– alter profile
– drop profile
recover
rename
resource – alter resource cost
revoke
rman – recovery manager
role – create role
– set role
– alter role
– drop role
rollback
rollback – create rollback segment
– alter rollback segment
– drop rollback segment
savepoint
schema – create schema
select
sequence – create sequence
– alter sequence
– drop sequence
session – alter session
shutdown
snapshot
spfile – create spfile
startup
statistics – associate statistics
– disassociate statistics
synonym – create synonym
– drop synonym
system – alter system
table – create table
– alter table
– drop table
tablespace – create tablespace
– alter tablespace
– drop tablespace
– create temporary tablespace
transaction – set transaction
trigger – create trigger
– alter trigger
– drop trigger
truncate
type – create type
– alter type
– drop type
– create type body
– drop type body
update
union
user – create user
– alter user
– drop user
view – create view
– alter view
– drop view