加入收藏 | 设为首页 | 会员中心 | 我要投稿 财气旺网 - 财气网 (https://www.caiqiwang.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 综合聚焦 > 编程要点 > 语言 > 正文

一个oracle指令的好 实例

发布时间:2022-11-15 11:21:51 所属栏目:语言 来源:
导读:  今天发现了一个显示ORACLE语法的好网站。内容太多,就不一一摘录了,记在这里,也方便自己查找。
  
  目录如下:
  
  An A-Z Index of Oracle SQL Commands (version 9.2)
  
  ANALYZE
 
  今天发现了一个显示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
 

(编辑:财气旺网 - 财气网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!