Re: sql syntax question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 11 Jun 1999 17:12:17 GMT
Message-ID: <37654359.7031761@newshost.us.oracle.com>

A copy of this was sent to "Joet Singh" <jsingh_at_bigfoot.com> (if that email address didn't require changing) On Fri, 11 Jun 1999 11:57:37 -0500, you wrote:

>I am trying to create a table with column XXXX and it has a range of values,
>say 1-50. Can I do this without creating a foreign key? Btw iam using
>oracle 8.0/sql 8.0
>
>
>

create table t ( x int check ( x between 1 and 50 ) );

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Jun 11 1999 - 12:12:17 CDT