add

About Me

My photo
Oracle Apps - Techno Functional consultant

Monday, April 2

Oracle SQL commands


   ANALYZE
   AUDIT
c
   CALL
   Cluster - CREATE CLUSTER
           - ALTER  CLUSTER
           - DROP   CLUSTER
   COMMENT
   COMMIT
   CONNECT
   CONSTRAINT - Add / Enable
   Context - CREATE CONTEXT
           - DROP CONTEXT
   Controlfile - CREATE CONTROLFILE
d
   Database - CREATE DATABASE
            - ALTER  DATABASE
   DELETE
   DESCRIBE
   Dimension - CREATE DIMENSION
             - ALTER DIMENSION
             - DROP DIMENSION
   Directory - CREATE DIRECTORY
             - DROP DIRECTORY
e
   EXEC
f
   Function - CREATE FUNCTION
         - ALTER  FUNCTION
         - DROP   FUNCTION
g
   GRANT
i
   Index - CREATE INDEX
         - ALTER  INDEX
         - DROP   INDEX
   Indextype - CREATE INDEXTYPE
             - DROP INDEXTYPE
   INSERT
j
   Java - CREATE JAVA
        - ALTER JAVA
        - DROP JAVA
l
   Library - CREATE LIBRARY
           - DROP LIBRARY
        - DROP DATABASE LINK
m
         - ALTER MATERIALIZED VIEW
         - DROP MATERIALIZED VIEW
         - CREATE MATERIALIZED VIEW LOG
         - ALTER MATERIALIZED VIEW LOG
         - DROP MATERIALIZED VIEW LOG
   MINUS
n
   NOAUDIT
o
   Operator - CREATE OPERATOR
            - DROP OPERATOR
   Outline - CREATE OUTLINE
           - ALTER OUTLINE
           - DROP OUTLINE
p
   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
r
   RECOVER
   RENAME
   Resource - ALTER RESOURCE COST
   REVOKE
   Role - CREATE ROLE
        - SET    ROLE
        - ALTER  ROLE
        - DROP   ROLE
   Rollback - CREATE ROLLBACK SEGMENT
            - ALTER  ROLLBACK SEGMENT
            - DROP   ROLLBACK SEGMENT
s
   Schema - CREATE SCHEMA
   SELECT
   Sequence - CREATE SEQUENCE
            - ALTER  SEQUENCE
            - DROP   SEQUENCE
   Session - ALTER SESSION
   SPfile - CREATE SPFILE
   STARTUP
   Statistics - ASSOCIATE STATISTICS
              - DISASSOCIATE STATISTICS
   Synonym - CREATE SYNONYM
           - DROP   SYNONYM
   System - ALTER SYSTEM
t
   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
   Type - CREATE TYPE
        - ALTER TYPE
        - DROP TYPE
        - CREATE TYPE BODY
        - DROP TYPE BODY
u
   UPDATE
   UNION
   User - CREATE USER
        - ALTER  USER
        - DROP   USER
v
   View - CREATE VIEW
        - ALTER  VIEW
        - DROP   VIEW
w
   WHERE

No comments: