EXTRACT(month FROM a.birth_date)
TO_CHAR(a.birth_date, 'YYYY')
TO_CHAR(a.birth_date, 'WW')
ADD_MONTHS(SYSDATE, -1)
TO_CHAR(NUMBER_FIELD)
CONCAT('a', 'b')
TO_CHAR(a) || '_' || TO_CHAR(b)
NVL(FIELD, 0)
CASE
WHEN FIELD <= 0.5 THEN 0
ELSE 1
END AS FIELD_BINARY
LONG_STRING_COL LIKE '%CAT%'
SELECT SYSDATE FROM DUAL
...
SELECT column1 FROM TABLE ORDER BY column1;
SELECT column1 FROM TABLE ORDER BY column1 DESC;
HAVING DATE = MAX(DATE);
SELECT * FROM TABLE WHERE
TO_CHAR(COLUMN, 'DY') = 'SAT' or
TRIM(INITCAP(TO_CHAR(COLUMN, 'DAY'))) = 'Friday'
NEXT_DAY(TRUNC(SYSDATE),'FRIDAY') - 7
NEXT_DAY(TRUNC(SYSDATE - 1), 'FRIDAY') - 7
SELECT * FROM employees WHERE ROWNUM < N;
WITH CTE AS (SELECT * FROM TABLE),
CTE2 AS (SELECT a.* FROM CTE a)
SELECT b.* FROM CTE2 b
DELETE FROM TABLE WHERE X IS MISSING;
ALTER TABLE TABLE_NAME DROP COLUMN COLUMN_NAME, COLUMN_NAME2;
CREATE TABLE COPIED_TABLE AS SELECT * FROM TABLETOCOPY;
CREATE INDEX IX ON TABLE (COLUMN)
CREATE OR REPLACE VIEW V_TABLENAME AS ...
SELECT
tablespace_name
,ROUND (SUM (bytes) / 1024 / 1024 / 1024, 2) GB
FROM dba_segments
WHERE owner = 'SCHEMA'
GROUP BY tablespace_name;
SELECT x.sid,
x.serial#,
x.username,
x.sql_id,
x.status,
x.sql_child_number,
optimizer_mode,
hash_value,
address,
sql_exec_start,
sql_text
FROM v$sqlarea sqlarea,
v$session x
WHERE x.sql_hash_value = sqlarea.hash_value
AND x.sql_address = sqlarea.address
AND x.username = 'USERNAME'