Sql Commands
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sql Commands as PDF for free.
More details
- Words: 369
- Pages: 4
An AZ 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 MINUS
CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW DROP MATERIALIZED VIEW CREATE MATERIALIZED VIEW LOG ALTER MATERIALIZED VIEW LOG DROP MATERIALIZED VIEW LOG
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 - DROP SYNTAX:
VIEW VIEW
Java - CREATE JAVA - ALTER JAVA - DROP JAVA Library - CREATE LIBRARY - DROP LIBRARY Link - CREATE DATABASE LINK - DROP DATABASE LINK LOCK TABLE Mview MINUS
CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW DROP MATERIALIZED VIEW CREATE MATERIALIZED VIEW LOG ALTER MATERIALIZED VIEW LOG DROP MATERIALIZED VIEW LOG
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 - DROP SYNTAX:
VIEW VIEW
Related Documents
Sql Commands
May 2020 13
Sql Commands
November 2019 8
Sql Commands
May 2020 7
Basic Commands In Sql Server
April 2020 15
My Sql Trial Commands (1)
November 2019 9