欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

一个oracle指令的好网站

程序员文章站 2023-08-14 12:59:33
今天发现了一个显示oracle语法的好网站。内容太多,就不一一摘录了,记在这里,也方便自己查找。 目录如下: an a-z index of oracle sql...

今天发现了一个显示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