اطلاعیه

Collapse
No announcement yet.

An A-Z Index of Oracle SQL Commands (version 9.2)

Collapse
X
 
  • Filter
  • زمان
  • Show
Clear All
new posts

  • An A-Z Index of Oracle SQL Commands (version 9.2)

    کد:
    [LEFT]An A-Z Index of Oracle SQL Commands (version 9.2) 
    
    ANALYZE
    AUDIT
    CALL
    CLUSTER - CREATE CLUSTER
    CLUSTER - ALTER  CLUSTER
    CLUSTER - DROP   CLUSTER
    COMMENT
    COMMIT
    CONNECT
    CONSTRAINT - Add / Enable
    CONTEXT - CREATE CONTEXT
    CONTEXT - DROP CONTEXT
    CONTROLFILE - CREATE CONTROLFILE
    
    DATABASE - CREATE DATABASE
    DATABASE - ALTER  DATABASE
    DELETE
    DESCRIBE
    DIMENSION - CREATE DIMENSION
    DIMENSION - ALTER DIMENSION
    DIMENSION - DROP DIMENSION
    DIRECTORY - CREATE DIRECTORY
    DIRECTORY - DROP DIRECTORY
    
    EXEC
    EXECUTE IMMEDIATE
    EXPLAIN PLAN
    
    FUNCTION - CREATE FUNCTION
    FUNCTION - ALTER  FUNCTION
    FUNCTION - DROP   FUNCTION
    
    GRANT
    
    INDEX - CREATE INDEX
    INDEX - ALTER  INDEX
    INDEX - DROP   INDEX
    INDEXTYPE - CREATE INDEXTYPE
    INDEXTYPE - DROP INDEXTYPE
    INSERT
    INTERSECT
    
    JAVA - CREATE JAVA
    JAVA - ALTER JAVA
    JAVA - DROP JAVA
    
    LIBRARY - CREATE LIBRARY
    LIBRARY - DROP LIBRARY
    LINK - CREATE DATABASE LINK
    LINK - DROP DATABASE LINK
    LOCK TABLE
    
    MVIEW - CREATE MATERIALIZED VIEW
    MVIEW - ALTER MATERIALIZED VIEW
    MVIEW - DROP MATERIALIZED VIEW
    MVIEW - CREATE MATERIALIZED VIEW LOG
    MVIEW - ALTER MATERIALIZED VIEW LOG
    MVIEW - DROP MATERIALIZED VIEW LOG
    MINUS
    
    NOAUDIT
    
    OPERATOR - CREATE OPERATOR
    OPERATOR - DROP OPERATOR
    OUTLINE - CREATE OUTLINE
    OUTLINE - ALTER OUTLINE
    OUTLINE - DROP OUTLINE
    
    PACKAGE - CREATE PACKAGE/BODY
    PACKAGE - ALTER  PACKAGE
    PACKAGE - DROP   PACKAGE
    PFILE - CREATE PFILE
    PROCEDURE - CREATE PROCEDURE
    PROCEDURE - ALTER  PROCEDURE
    PROCEDURE - DROP   PROCEDURE
    PROFILE - CREATE PROFILE
    PROFILE - ALTER  PROFILE
    PROFILE - DROP   PROFILE
    
    RECOVER
    RENAME
    RESOURCE - ALTER RESOURCE COST
    REVOKE
    RMAN - Recovery Manager
    ROLE - CREATE ROLE
    ROLE - SET    ROLE
    ROLE - ALTER  ROLE
    ROLE - DROP   ROLE
    ROLLBACK
    ROLLBACK - CREATE ROLLBACK SEGMENT
    ROLLBACK - ALTER  ROLLBACK SEGMENT
    ROLLBACK - DROP   ROLLBACK SEGMENT
    
    SAVEPOINT
    SCHEMA - CREATE SCHEMA
    SELECT
    SEQUENCE - CREATE SEQUENCE
    SEQUENCE - ALTER  SEQUENCE
    SEQUENCE - DROP   SEQUENCE
    SESSION - ALTER SESSION
    SHUTDOWN
    SNAPSHOT
    SPFILE - CREATE SPFILE
    STARTUP
    STATISTICS - ASSOCIATE STATISTICS
    STATISTICS - DISASSOCIATE STATISTICS
    SYNONYM - CREATE SYNONYM
    SYNONYM - DROP   SYNONYM
    SYSTEM - ALTER SYSTEM
    
    TABLE - CREATE TABLE
    TABLE - ALTER  TABLE
    TABLE - DROP   TABLE
    TABLESPACE - CREATE TABLESPACE
    TABLESPACE - ALTER  TABLESPACE
    TABLESPACE - DROP   TABLESPACE
    TABLESPACE - CREATE TEMPORARY TABLESPACE
    TRANSACTION - SET TRANSACTION
    TRIGGER - CREATE TRIGGER
    TRIGGER - ALTER  TRIGGER
    TRIGGER - DROP   TRIGGER
    TRUNCATE
    TYPE - CREATE TYPE
    TYPE - ALTER TYPE
    TYPE - DROP TYPE
    TYPE - CREATE TYPE BODY
    TYPE - DROP TYPE BODY
    
    UPDATE
    UNION
    USER - CREATE USER
    USER - ALTER  USER
    USER - DROP   USER
    
    VIEW - CREATE VIEW
    VIEW - ALTER  VIEW
    VIEW - DROP   VIEW
    
    [/LEFT]
    VIRANGAR SECURITY TEAM
Working...
X