create table mlhevents(event varchar(20) , month varchar(20) , startdate number , enddate number)Table created.
insert into mlhevents values('Hacktoon','july',9,11)1 row(s) inserted.
insert into mlhevents values('Bon Voyage Hacks','july',16,18)1 row(s) inserted.
insert into mlhevents values('Hacky Birthday MLH!','july',23,25)1 row(s) inserted.
insert into mlhevents values('SelfieHacks','july-Aug',30,1)1 row(s) inserted.
insert into mlhevents values('Robohacks','Aug',6,8)1 row(s) inserted.
insert into mlhevents values('Hosted By MLH','Aug',20,22)1 row(s) inserted.
insert into mlhevents values('Hosted By MLH','Aug',27,29)1 row(s) inserted.
insert into mlhevents values('Hosted By MLH','sep',3,5)1 row(s) inserted.
insert into mlhevents values('Hosted By MLH','sep',10,12)1 row(s) inserted.
insert into mlhevents values('Hosted By MLH','sep',17,19)1 row(s) inserted.
insert into mlhevents values('Hosted By MLH','sep',24,26)1 row(s) inserted.
desc mlheventsTABLE MLHEVENTS
| Column | Null? | Type | EVENT | - | VARCHAR2(20) | MONTH | - | VARCHAR2(20) | STARTDATE | - | NUMBER | ENDDATE | - | NUMBER |
|---|
select * from mlhevents| EVENT | MONTH | STARTDATE | ENDDATE | Hacktoon | july | 9 | 11 | Bon Voyage Hacks | july | 16 | 18 | Hacky Birthday MLH! | july | 23 | 25 | SelfieHacks | july-Aug | 30 | 1 | Robohacks | Aug | 6 | 8 | Hosted By MLH | Aug | 20 | 22 | Hosted By MLH | Aug | 27 | 29 | Hosted By MLH | sep | 3 | 5 | Hosted By MLH | sep | 10 | 12 | Hosted By MLH | sep | 17 | 19 | Hosted By MLH | sep | 24 | 26 |
|---|