国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > Oracle > 正文

一個oracle指令的好網站

2024-08-29 13:57:15
字體:
來源:轉載
供稿:網友

今天發現了一個顯示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

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 黄梅县| 青铜峡市| 松潘县| 女性| 万山特区| 邢台县| 府谷县| 南丹县| 新野县| 吉隆县| 平潭县| 碌曲县| 周宁县| 信宜市| 大关县| 四平市| 大连市| 宿松县| 丹阳市| 胶州市| 徐汇区| 徐州市| 容城县| 太白县| 江源县| 新疆| 五大连池市| 聂拉木县| 萝北县| 四会市| 当涂县| 水富县| 阳山县| 富平县| 龙州县| 桦甸市| 德昌县| 博野县| 棋牌| 葫芦岛市| 思南县|