Re: Oracle and PICK

From: Tony <andrewst_at_onetel.net.uk>
Date: 17 Apr 2004 10:34:31 -0700
Message-ID: <c0e3f26e.0404170934.1a2b681f@posting.google.com>

"Nick" <nquinnusa_at_earthlink.net> wrote in message news:<En9gc.12444$zj3.2949_at_newsread3.news.atl.earthlink.net>...
> Excuse please, was looking for the column elements of the three dimensional
> array with associated multiple instances of a column defined as in
> CREATE TABLE contract
> (
> ContractNo VARCHAR(16) NULL,
> ContractYear VARCHAR(16) NULL,
> ContractVersion VARCHAR(3) NULL,
> Co VARCHAR(16) NULL,
> MasterKey VARCHAR(24) NULL,
> Brkr VARCHAR(16) NULL,
> BrkrDesc VARCHAR(120) NULL,
> Cedant VARCHAR(16) NULL,
> )
> CREATE UNIQUE INDEX ContractId ON contract
> ( Co, ContractNo, ContractYear, ContractVersion )

What is the difference, apart from the fact that my CREATE TABLE statement was on a single line and I omitted to define the obvious key? Does this make it better for you? :-

CREATE TABLE three_dimensional_point
(

 x int,
 y int,
 z int,

 PRIMARY KEY (x, y, z)
 ); Received on Sat Apr 17 2004 - 12:34:31 CDT