receiving the error "missing right parenthesis".
The only other relational work that I've done was in mySQL so I'm
sure that it's a syntax or keyword Oracle issue.
Here's the two tables and it's the second one that gives me the error:
<!--- worked aok --->
create table fsnep_polls (
p_id NUMBER Primary Key,
p_date_added date,
p_date_last_used date,
p_question VARCHAR2(400),
p_status NUMBER
)
CREATE SEQUENCE unique_poll_Num_s START WITH 1
<!--- ***I receive an error here***--->
<!-- all possible answers for any poll available -->
create table fsnep_pollAnswers (
pA_id NUMBER Primary Key,
pA_pollID NUMBER Foreign Key REFERENCES fsnep_polls(p_id),
pA_answer NUMBER
)
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
