当前位置: 首页 > 图文教程 > 数据库 > Oracle > 一个oracle指令的好网站

Oracle
Oracle 9i轻松取得建表和索引的DDL语句
Oracle 8x监控sysdba角色用户登陆情况
PB7 连接 Oracle 的设置方法
Oracle数据库的备份及恢复策略研究
Oracle三种上载文件技术
Oracle建立二进制文件索引的方法
Oracle数据库及应用程序优化开发者网络Oracle
Oracle PL/SQL入门慨述
Oracle PL/SQL入门案例实践
基于Oracle的面向对象技术入门基础简析开发者网络Oracle
PL/SQL编程经验小结开发者网络Oracle
Oracle的数据字典技术简析
基于Oracle的高性能动态SQL程序开发
Oracle9i取得建表和索引的DDL语句
PL/SQL实现Oracle数据库任务调度
Oracle 9i 数据库异常关闭后的启动
Oracle与SQL Server在企业应用的比较
Oracle捕获问题SQL解决CPU过渡消耗
Oracle平台应用数据库系统的设计与开发
Oracle使用PL/SQL操作COM对象

No. « 4 5 6 7 »

技术文章搜索

关键字

Oracle 中的 一个oracle指令的好网站

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 67 ::
收藏到网摘: n/a

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

http://www.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