Re: Oracle and PICK

"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,