SQL

SELECT (SIMPLE)

DISTINCT

Q

TIPOS DE DATOS

DESCRIBE

WHERE

OPERADORES

ORDER BY

VARIABLE DE SUSTITUCION &

DEFINE / UNDEFINE

VERIFY

NVL 

NVL2

NULLIF

COALESCE

CASE

DECODE

LOWER

UPPER

INITCAP

CONCAT

SUBSTR

LENGTH

LENGTH2

LENGTH4

LENGTHB

LENGTHC

INSTR

INSTR2

INSTR4

INSTRB

INSTRC

UNISTR

LPAD

RPAD

TRIM

RTRIM

LTRIM

REPLACE

REVERSE

CHR

ROUND

TRUNC

MOD

SYSDATE

DUAL

MONTHS_BETWEEN

ADD_MONTHS

NEXT_DAY

LAST_DAY

TO_NUMBER

TO_DATE

TO_CHAR

TO_TIMESTAMP

TO_TIMESTAMP_TZ

TO_YMINTERVAL

MODELOS DE FORMATO DE FECHAS Y NUMEROS

FORMATO DE FECHA RR

FUNCIONES ANIDADAS

CASE 

DECODE

MAX

MIN

SUM

AVG

COUNT 

STDDEV

VARIANCE

GROUP BY 

HAVING

NATURAL JOIN

JOIN ON

JOIN USING

LEFT OUTER JOIN

RIGHT OUTER JOIN

FULL OUTER JOIN

CROSS JOIN

JOIN SIN CLAUSULA JOIN

NON EQUI JOIN

ALIAS

SUBQUERY

TIPOS DE SUBQUERIES

SUBQUERY DE UNA SOLA FILA

SUBQUERY DE VARIAS FILAS

SUBQUERY CORRELACIONAL

UNION

UNION ALL

INTERSET

MINUS

COLUMNAS FICTICIAS Y LAS FUNCIONES DE CONVERSIÓN 

DML

DDL

DCL

TCL

INSERT(SIMPLE)

INSERT WHIT CHECK OPTION

INSERT ALL 

INSERT ALL CONDITIONAL

INSERT FIRST

INSERT PIVOTING

MERGE

UPDATE 

DELETE

VERSIONS BETWEEN SCN 

TRUNCATE

TRANSACCIONES DE BASE DE DATOS

COMMIT

ROLLBACK

SAVEPOINT

TABLES

DROP GENERAL

DROP TABLE

DROP CASCADE CONTRAINT

SEQUENCE

NEXTVAL

CURRVAL

INDEX

SYNONYM

CONSTRAINT

ADD

DROP

DISABLE

ENABLE

MODIFY

RENAME

UNUSED

GENERATED

NOT NULL

UNIQUE

PRIMARY KEY

FOREIGN KEY

CHECK

ON DELETE CASCADE / ON DELETE SET NULL

ALTER TABLE

VIEW 

MATERIALIZED VIEW

WITH CHECK OPTION 

WITH READ ONLY

DICCIONARIO DE DATOS

CREATE USER

PRIVILEGIOS

GRANT

REVOKE

WITH GRANT OPTION 

ROL

CAMBIAR PASSWORD

DEFERRABLE O NOT DEFERRABLE

PURGE

FLASHBACK

DIRECTORY

CREACION DE TABLA EXTERNA 

ROLLUP

CUBE

GROUPING SETS

GROUPING

COLUMNAS COMPUESTAS

PIVOT

UNPIVOT

TZ_OFFSET

FROM_TZ

CURRENT_DATE

CURRENT_TIMESTAMP

LOCALTIMESTAMP

DBTIMEZONE

SESSIONTIMEZONE

EXTRACT

EXISTS

WITH

GREATEST

LEAST

RECUPERACION JERARQUICA

METACARACTERES

REGEXP_LIKE

REGEXP_REPLACE

REGEXP_INSTR

REGEXP_SUBSTR