Home » SQL & PL/SQL » SQL & PL/SQL » constraint deferred
constraint deferred [message #199294] Mon, 23 October 2006 04:49 Go to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
is this option invalid?


SQL> create table patient(id# int, pname varchar2(30) constraint patient_id_pk primary key(id#) deferrable initially immediate);

create table patient(id# int, pname varchar2(30) constraint patient_id_pk primary key(id#) deferrable initially immediate)

ORA-00907: missing right parenthesis

SQL> 



i've achieved the same using alter table, is the option above not possible? or is there anything wrong with the syntax? thank you so much sir/mam.

[Updated on: Mon, 23 October 2006 04:50]

Report message to a moderator

Re: constraint deferred [message #199296 is a reply to message #199294] Mon, 23 October 2006 04:56 Go to previous messageGo to next message
Alien
Messages: 245
Registered: June 1999
Senior Member
Hi,

create table patient(id# int constraint patient_id_pk primary key deferrable initially immediate, pname varchar2(30) );

Re: constraint deferred [message #199297 is a reply to message #199296] Mon, 23 October 2006 05:02 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
thanks for the reply, i was trying to create a "table level" constraint definition, i just saw in some tutorials where they put the constraint part after all the column have been defined, thanks again =)
Previous Topic: connect by - too many rows?
Next Topic: Grouping Question
Goto Forum:
  


Current Time: Sun Dec 11 06:23:19 CST 2016

Total time taken to generate the page: 0.19585 seconds