SQL and PL/SQL

SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source

SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source WHERE column_name operator value

UPDATE table_name SET column_name = new_value WHERE column_name = some_value

Union is the product of two or more tables.

SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.

Minus is the product of two tables listing only the non-matching rows.