Re: limit TABLE to only one record

On Wed, 14 Nov 2007 13:55:54 -0500, Brian Tkatch <N/A> wrote:

>I am looking to store an easily modifiable value that a VIEW can use,
>without issuing any DDL statements. I'm guessing that a TABLE with one
>record would be a good way. The question then is how to limit a TABLE
>to only one record:
>
>CREATE TABLE One_Record_Only
>(
> Id INT DEFAULT 1,
> Data INT,
> CONSTRAINT ORO1_Id_NN CHECK(Id IS NOT NULL),
> CONSTRAINT ORO1_Id_CK CHECK(Id = 1),
> CONSTRAINT ORO1_Id_PK PRIMARY KEY(Id)
> USING INDEX (CREATE UNIQUE INDEX ORO1_Id_PK ON One_Record_Only(Id))
>);
>
> Is there a more straightforward emthod to limit a TABLE to only one
>record?
>
> Is there another way to accomplish the same goal?
>
>B.

A more straightforward method would be using the correct constraint syntax.

-- 
Sybrand Bakker
Senior Oracle DBA