SQL developer
-------------------------------------------------------- -------------------------------------------------------- -------------------------------------------------------- -- DDL for Table TEAM -------------------------------------------------------- CREATE TABLE "TEAM" ( "TEAM_ID" VARCHAR2(3) not null primary key, "TEAM_NAME" VARCHAR2(35), "TEAM_CONFERENCE" VARCHAR2(25), "TEAM_DIVISION" VARCHAR2(25) ) ; / REM INSERTING into TEAM SET DEFINE OFF; Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('ANA','Anaheim Mighty Ducks ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('BOS','Boston Bruins ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('BUF','Buffalo Sabres ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('CAR','Carolina Hurricanes ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('CBJ','Columbus Blue Jackets ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('CGY','Calgary Flames ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('CHI','Chicago Blackhawks ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('COL','Colorado Avalanche ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('DAL','Dallas Stars ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('DET','Detroit Red Wings ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('EDM','Edmonton Oilers ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('FLA','Florida Panthers ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('LAK','LA Kings ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('MIN','Minnesota Wild ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('MTL','Montreal Canadians ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('NJD','New Jersey Devils ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('NSH','Nashville Predators ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('NYI','New York Islanders ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('NYR','New York Rangers ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('OTT','Ottawa Senators ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('PHI','Philadelphia Flyers ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('ARI','Arizona Coyotes ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('PIT','Pittsburgh Penguins ','Eastern','Metro'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('SJS','San Jose Sharks ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('STL','St. Louis Blues ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('TBL','Tampa Bay Lightening ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('TOR','Toronto Maple Leafs ','Eastern','Atlantic'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('VAN','Vancouver Canucks ','Western','Pacific'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('WPG','Winnepeg Jets ','Western','Central'); Insert into TEAM (TEAM_ID,TEAM_NAME,TEAM_CONFERENCE,TEAM_DIVISION) values ('WSH','Washington Capitals ','Eastern','Metro'); commit;