一个oracle指令的好网站
今天发现了一个显示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