People That Know SQL, Care to Lend a Hand?

"Dwhite - Powered by Caffeine, Daft Punk, and Corgis" (Dwhite95) 12/14/2015 at 15:56 • Filed to: None

0

4

Boring stuff after the jump, have some Alfa’s

For our final project we need to build and populate a database in Oracle. When we try populate a few tables we are getting some errors. .

So with this statement here:

INSERT INTO PlaysIn VALUES (‘000000001’,’Arizona Cardinals’,’Baltimore Ravens’, TO_DATE(‘10/10/15’, ‘MM/DD/YY’);

I get an error of “ORA-00917: missing comma”

Table details here:

CREATE TABLE PlaysIn (

playerID number(9),
team1 varchar2(30),
team2 varchar2(30),
pDate date,
CONSTRAINT PlaysIn_pk PRIMARY KEY (playerID, team1, team2, pDate),
CONSTRAINT PlaysIn_fk1 FOREIGN KEY (playerID) REFERENCES Player(playerID),
CONSTRAINT PlaysIn_fk2 FOREIGN KEY (team1, team2, pDate) REFERENCES Game(team1, team2, pDate));

Any ideas?

crowmolly > Dwhite - Powered by Caffeine, Daft Punk, and Corgis 12/14/2015 at 16:01

2

INSERT INTO PlaysIn VALUES (‘000000001’,’Arizona Cardinals’,’Baltimore Ravens’, TO_DATE(‘10/10/15’, ‘MM/DD/YY’) ) ;

Looks like you may be missing a closing parentheses?

Dwhite - Powered by Caffeine, Daft Punk, and Corgis > crowmolly 12/14/2015 at 16:09

0

Nice catch, I’m gonna go look at that.

Eric @ opposite-lock.com > Dwhite - Powered by Caffeine, Daft Punk, and Corgis 12/14/2015 at 16:11

0

Beyond what crowm... mentioned, if you're copy-pasting that, the single quotes are a Unicode mess.

davesaddiction @ opposite-lock.com > crowmolly 12/14/2015 at 16:36

0

That’s what I saw first, too.