PL/SQL (MOSC)

MOSC Banner

SQL query with day view

edited Sep 1, 2015 10:00AM in PL/SQL (MOSC) 8 commentsAnswered

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center