加入收藏 | 设为首页 | 会员中心 | 我要投稿 云计算网_泰州站长网 (http://www.0523zz.com/)- 视觉智能、AI应用、CDN、行业物联网、智能数字人!
当前位置: 首页 > 综合聚焦 > 编程要点 > 语言 > 正文

一个oracle指令的好实例

发布时间:2022-01-04 02:48:09 所属栏目:语言 来源:互联网
导读:今天发现了一个显示ORACLE语法的好网站。内容太多,就不一一摘录了,记在这里,也方便自己查找。 目录如下: An A-Z Index of Oracle SQL Commands (version 9.2) ANALYZE AUDIT CALL Cluster - CREATE CLUSTER - ALTER CLUSTER - DROP CLUSTER COMMENT COM
今天发现了一个显示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

(编辑:云计算网_泰州站长网)

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

    热点阅读