Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone2.usenetserver.com!newsfeeds-atl1.usenetserver.com!news.webusenet.com!pc01.webusenet.com!news.bellsouth.net.POSTED!not-for-mail From: "Bob Redding" Newsgroups: comp.databases.oracle.misc References: <3dcfbd65$0$1289$ed9e5944@reading.news.pipex.net> Subject: Re: Combined Primary Key Lines: 35 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: X-Complaints-To: abuse@usenetserver.com X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly. NNTP-Posting-Date: Mon, 11 Nov 2002 12:21:59 EST Organization: WEBUSENET.com Date: Mon, 11 Nov 2002 12:38:21 -0500 Xref: newsfeed1.easynews.com comp.databases.oracle.misc:89211 X-Received-Date: Mon, 11 Nov 2002 10:37:12 MST (news.easynews.com) Use them all the time, which is very handy for importing from more than one source into an Oracle table. Hope not to incite a flame war, but I think anything you can do in MS SQL Server, you can do better in Oracle. "Niall Litchfield" wrote in message news:3dcfbd65$0$1289$ed9e5944@reading.news.pipex.net... > The simple answer is yes. > > SQL> @create_composite_primary_key_eg > > Table created. > > SQL> ; > 1 CREATE TABLE tab1( > 2 region_id number, > 3 order_id number, > 4 CONSTRAINT pk_tab1 PRIMARY KEY( region_id,order_id)) > 5* TABLESPACE users > SQL> > > > "PABLO" wrote in message > news:fb04eea9.0211110607.663a5407@posting.google.com... > > Hi, I wonder if I can create in Oracle a Primary Key composed by 2 > > fields of the table, like I do in MS SQL Server. > > > > Thanks, > > > > Pablo > >