Foreign composite keys

From: Gabe Goldhirsh <ggoldh1_at_triton.towson.edu>
Date: 1997/06/17
Message-ID: <33A68D04.425B@triton.towson.edu>#1/1

In ORACLE 7, what is the syntax for constructing a foreign composite key, so far I have: [and am still getting an error] DROP TABLE account;
CREATE TABLE account
(

server          VARCHAR2(15),
memory          VARCHAR2(15),
classification  VARCHAR2(15),
user_id         VARCHAR2(15),
password        VARCHAR2(15),

FOREIGN KEY (user_id)
AND FOREIGN KEY (password)
); Received on Tue Jun 17 1997 - 00:00:00 CDT