This is my first time using Oracle SQL Developer and the statements I'm used to using in MS SQL Server seems to not work on this environment say for example with the use of the following Query:

Code:
/* Code by K0502201*/
CREATE TABLE tblPrice
(
	StoreID		SMALLINT	REFERENCES tblStore(StoreID),
	ProdCode	CHAR(8)		REFERENCES tblProduct(ProdCode),
	PricePU		NUMERIC(4,2)

	CONSTRAINT PriceCK PRIMARY KEY
		(StoreID, ProdCode)
);
It gave me the following error:

Code:
Error at Command Line:8 Column:2
Error report:
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
*Cause:    
*Action:
Which doesn't make sense at all to me. Both tblStore and tblProduct has already been created

Any help is greatly appreciated.