Overblog Suivre ce blog
Editer l'article Administration Créer mon blog
15 avril 2012 7 15 /04 /avril /2012 16:06

 

commande sql oracleCOMMANDES SQL ORACLE.

Les commandes sql oracle listées ci-dessous sont toutes accompagnées d'exemple d'utilisation testés sous Oracle 10G.

 

COMMANDES SQL DDL - DATA DEFINITION LANGUAGE.

  1. CREATE DATABASE.
  2. CREATE TABLESPACE.
  3. CREATE USER.
  4. CREATE SCHEMA.
  5. CREATE TABLE.
  6. CREATE EXTERNAL TABLE.
  7. CREATE SYNONYM.
  8. CREATE VIEW.
  9. CREATE ROLE.
  10. CREATE SEQUENCE.
  11. CREATE DIRECTORY.
  12. ALTER TABLESPACE.
  13. ALTER USER.
  14. ALTER TABLE MODIFY.
  15. ALTER TABLE ADD COLUMN.
  16. ALTER TABLE RENAME COLUMN.
  17. ALTER TABLE RENAME TO.
  18. ALTER TABLE DROP COLUMN.
  19. ALTER SEQUENCE.
  20. ALTER VIEW.
  21. DROP DATABASE.
  22. DROP TABLESPACE.
  23. DROP TABLE.
  24. DROP SEQUENCE.
  25. DROP SYNONYM.
  26. PURGE TABLE.
  27. TRUNCATE TABLE.
  28. GRANT.
  29. REVOKE.
  30. AUDIT.

COMMANDES SQL DML - DATA MANIPULATION LANGUAGE..

  1. SELECT FROM.
  2. INSERT INTO.
  3. INSERT ALL.
  4. MERGE INTO.
  5. UPDATE.
  6. DELETE.
  7. EXPLAIN PLAN.

COMMANDES SQL SYSTEM CONTROL LANGUAGES.

  1. ALTER SYSTEM KILL / DISCONNECT SESSION.
  2. ALTER SYSTEM SWITCH LOGFILE.
  3. ALTER SYSTEM ENABLE RESTRICTED SESSION.
  4. ALTER SYSTEM SET JOB_QUEUE_PROCESSES.
  5. ALTER SYSTEM SET ARCHIVE_LAG_TARGET.
  6. ALTER SYSTEM SET DB_FILE_MULTIBLOCK_READ_COUNT.
  7. ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE.

COMMANDES SQL SESSION CONTROL LANGUAGES.

  1. ALTER SESSION SET RECYCLEBIN.

COMMANDES SQL TRANSACTION CONTROL LANGUAGES.

  1. COMMIT - ROLLBACK - SAVEPOINT.

















































Partager cet article

Repost 0
Published by Daniel Roesch - dans COMMANDES SQL DML-LMD
commenter cet article

commentaires