一个oracle指令的好网站

来源:asp之家 时间:2010-07-21 13:31:00 

今天发现了一个显示ORACLE语法的好网站。内容太多,就不一一摘录了,记在这里,也方便自己查找。

http://ss64.com/ora/

目录如下:

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

标签:oracle,指令,语法
0
投稿

猜你喜欢

  • asp 输出换行的详细说明 原创

    2011-02-24 11:15:00
  • Web开发的改良

    2009-06-25 14:34:00
  • asp程序定义变量比不定义变量速度快一倍

    2012-12-04 20:06:32
  • 经典SQL语句大全

    2009-08-26 16:44:00
  • 我的栅格系统实现

    2008-09-21 13:50:00
  • CSS结合js实现动态更换皮肤

    2007-07-14 10:01:00
  • 图文教程教你asp编译成dll组件

    2010-07-16 13:16:00
  • 对“关于购物车的想法”的一些回复

    2009-03-10 18:15:00
  • 细线表格的处理

    2008-08-06 12:53:00
  • 有故事的网页设计——Flash网站奇妙之旅

    2011-01-20 19:58:00
  • SQL Server 2005 五个动态管理对象

    2008-12-18 14:50:00
  • IE6绝对定位的bug及其解决办法

    2011-03-30 12:31:00
  • Oracle 数据 使用游标

    2009-07-02 12:14:00
  • 高效率的GetRows()的使用方法

    2008-09-23 18:29:00
  • 对mysql表进行优化、分析、检查和修复的说明

    2010-04-22 16:28:00
  • CSS+asp仿迅雷人气指数

    2009-08-03 14:11:00
  • 用 iframe 解决下拉框与层之冲突

    2008-04-28 12:24:00
  • 构建成功web应用的十项黄金法则

    2010-09-17 19:11:00
  • js读取图片的宽和高

    2007-08-04 10:14:00
  • 学习ASP.NET八天入门:第四天

    2007-08-07 13:40:00
  • asp之家 网络编程 m.aspxhome.com