一个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

(0)
上一篇 2022年3月22日
下一篇 2022年3月22日

相关推荐