SQL query with day view
I have following table. Here there are food items for each date.I wan to get a query result base on week days like Monday Tuesday Thursday. see below picture for detail
Expected result based on day of the week
DDL
create table MENU_TAB
menu_date DATE not null,
item_name VARCHAR2(100) not null,
vegetarian_special VARCHAR2(5) default 'FALSE' not null
DML
prompt PL/SQL Developer import file
prompt Created on Wednesday, August 26, 2015 by japalk
set feedback off
set define off
prompt Loading MENU_TAB...
insert into MENU_TAB (menu_date, item_name, vegetarian_special)
values (to_date('03-07-2015', 'dd-mm-yyyy'), 'Pol Roti', 'FALSE');