sql_oracle

Tips and tricks for writing sql data queries for extracting data from a data base. This is largely general information, but some of it might be specific to writing queries for oracle data bases.

List of all available table names

SELECT table_name
FROM all_tables
ORDER BY table_name;

Subset for distinct rows

SELECT DISTINCT columname1, columnname2
FROM database.table;