CODE EXAMPLE FOR SQL

oracle sql all days except weekends

WHERE TO_CHAR(date_column, 'DY','NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN')