Find out if the date from table A is a weekday or a weekend
PL/SQL Block Oracle Database
Â
Scenario
Â
Find out if the date from table A is a weekday or a weekend
Â
CREATE TABLE A
(A_ID VARCHAR2(30),
date_a    DATE DEFAULT SYSDATE, Â
CONSTRAINT A_PK PRIMARY KEY (A_ID));
Â
Â
date_a is inserted with some random dates
Â
Â
CREATE TABLE B
(B_ID VARCHAR2(30),
date_desc   VARCHAR2(30), Â
CONSTRAINT B_PK PRIMARY KEY (B_ID));
Â
Â
Now, using PL/SQL Block, identify if date_a is a weekend or a weekday, if the date was a holiday(for example: New Year's Day, Martin Luther King Jr's Birthday, President's Day etc)
describe this instead to date_desc in table B.
Answers
Status NEW
Posted 12 Dec 2017 12:12 PM
My Price 7.00
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly
Not Rated(0)