繁體中文当前位置: 首页 > 图文教程 > 数据库 > Oracle > 一个oracle指令的好网站
- Oracle
- Excel VBA连接并操作Oracle
- Oracle 外连接实现代码
- oracle 存储过程和函数例子
- Oracle 数据库操作类
- ORACLE 分区表的设计
- Oracle 用户权限管理方法
- Oracle In和exists not in和not exists的比较分析
- 利用windows任务计划实现oracle的定期备份
- ORACLE11g随RHEL5系统自动启动与关闭的设置方法
- 在oracle 数据库查询的select 查询字段中关联其他表的方法
- plsql和tsql常用函数比对
- plsql与tsql的语法不同
- ASP.NET调用oracle存储过程实现快速分页
- 执行drop表操作后数据库无法起动
- 分析Oracle有时会用索引来查找数据的原因
- 数据从MySQL迁移到 Oracle的注意事项
- 快速理解Oracle归档模式的命令及参数
- 在Oracle里加快SQL执行的三种方法
- 几条常见的数据库分页 SQL 语句
- Oracle9I OCP认证过程
Oracle 中的 一个oracle指令的好网站
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 91 ::
收藏到网摘: n/a
今天发现了一个显示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
评论 (0) All
