Capítulos 3 & 4 — SELECT + WHERE en Oracle SQL

1. Una o varias columnas

-- Una columna
SELECT title_name
FROM TITLE;

-- Varias columnas
SELECT title_name, title_date
FROM TITLE;

1. Una o varias columnas

-- Una columna
SELECT title_name
FROM TITLE;

-- Varias columnas
SELECT title_name, title_date
FROM TITLE;

2. Alias con AS -> ESPACIOS = “XX XX XX”

SELECT title_name  AS "Nombre del Libro",
       title_date  AS "Fecha de Publicación"
FROM TITLE;

3. Operadores de comparación

-- Igual
SELECT title_name
FROM TITLE
WHERE publication_date = DATE '2015-04-30';

-- Mayor / menor
SELECT title_name
FROM TITLE
WHERE price > 5;

-- Diferente (Oracle acepta ambos)
SELECT title_name
FROM TITLE
WHERE price <> 10,95;

4. IN

-- En lugar de: WHERE type = 'F' OR type = 'NF'
SELECT TITLE_NAME, ROYALTY
FROM TITLE
WHERE ROYALTY IN (10, 12, 14);

5. LIKE

-- Títulos que empiecen con "The"
SELECT TITLE_NAME FROM TITLE WHERE TITLE_NAME LIKE 'The%';

-- Títulos que contengan "SQL" en cualquier parte
SELECT TITLE_NAME FROM TITLE WHERE TITLE_NAME LIKE '%SQL%';