Re: Problem using INTERVAL DAY TO SECOND

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<1Y6dnXAKSL05K8rdRVn-vA_at_comcast.com>...
> "Ram" <ramsnis_at_rediffmail.com> wrote in message
> news:3231117f.0403151939.f2bc5c0_at_posting.google.com...
> | Hello everyone,
> | I am getting a "ORA-00907: missing right parenthesis" error when i
> | am trying to create a table. The error lies in using the "INTERVAL DAY
> | TO SECOND"
> | in the create table statement. I am using Oracle 8i (windows 2000).
> |
> | Here is the error:
> |
> | SQL> CREATE TABLE project_consultant
> | 2 (p_id NUMBER(6),
> | 3 c_id NUMBER(6),
> | 4 roll_on_date DATE,
> | 5 roll_off_date DATE,
> | 6 elapsed_time INTERVAL DAY(6) TO SECOND,
> | 7 CONSTRAINT project_consultant_pk PRIMARY KEY (p_id, c_id),
> | 8 CONSTRAINT project_consultant_p_id_fk FOREIGN KEY (p_id)
> | REFERENCES project(p_id),
> | 9 CONSTRAINT project_consultant_c_id_fk FOREIGN KEY (c_id)
> | REFERENCES consultant(c_id));
> | elapsed_time INTERVAL DAY(6) TO SECOND,
> | *
> | ERROR at line 6:
> | ORA-00907: missing right parenthesis
> |
> | Could anyone please help me.
> |
> | Thanks,
> |
> | Ram
>
> i believe you're trying to use a 9i datatype in 8i
>
> ;-{ mcs

Hi Mark,
  Thanks for the answer. Received on Wed Mar 17 2004 - 22:55:01 CET