SENTENCIAS SQL

SENTENCIAS SQL

1. DDL (definicion de datos)

   • CREATE TABLE "TABLA";
   • DROP TABLE "TABLA";
   • ALTER TABLE "TABLA" ADD "COLUMNA" "TIPO";
   • CREATE VIEW "VISTA" AS SELECT * FROM "TABLA";
   • DROP VIEW "VISTA"

2. DML (manipulacion de datos)

   • SELECT * FROM "TABLA";
   • INSERT INTO "TABLA" (ATRIBUTO) VALUES ("ALGO");
   • UPDATE "TABLA" SET ATRIBUTO = "ALGO";
   • DELETE FROM "TABLA";

3. PLSQL (SQL programatico)

   • DECLARATE
   • OPEN
   • FETCH
   • CLOSE

4. DCL (control de accesos)

   • GRANT
   • REVOKE
   • COMMIT
   • ROLLBACK

5. GUTIERREZ MARTINEZ JOSE MANUEL SOLIS BALTAZAR ANDRES ISRAEL

Bilder und Dateien der Mindmap