Column NUMBERS accepting only a pre defined range of numbers

#1

Hello,

I have a table such as below. Is there a way to limit the range of
number so it does not exceed a predefined maximum limit?
For instance the maximum range for the ID column would 750 and if there
is an attemps to insert or update a record that contain a column with
845, it will return an error.

Thanks in advance for your help.
Wilfrid

CREATE TABLE orders
(
name VARCHAR2(20),
ID NUMBER(10),
dateofrecord DATE)
constraint pk_ID (ID)
)

#2

"Wilfrid" <grille12 (AT) gmail (DOT) com> a écrit dans le message de news: 4daadb68$0$23678$426a34cc (AT) news (DOT) free.fr...

Quote:

Hello,

I have a table such as below. Is there a way to limit the range of
number so it does not exceed a predefined maximum limit?
For instance the maximum range for the ID column would 750 and if there
is an attemps to insert or update a record that contain a column with
845, it will return an error.

Thanks in advance for your help.
Wilfrid

CREATE TABLE orders
(
name VARCHAR2(20),
ID NUMBER(10),
dateofrecord DATE)
constraint pk_ID (ID)
)

Have a look at constraint:
http://download.oracle.com/docs/cd/B...2.htm#g1053592

Regards
Michel

#3

On 4/17/2011 5:00 PM, Michel Cadot wrote:

Quote:

I am all set.
thanks

#4

Quote:

CREATE TABLE orders
(
name VARCHAR2(20),
ID NUMBER(10) CHECK (ID BETWEEN 1 AND 750),
dateofrecord DATE)
constraint pk_ID (ID)
)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Column NUMBERS accepting only a pre defined range of numbers

comp.databases.oracle.server comp.databases.oracle.server

Column NUMBERS accepting only a pre defined range of numbers - 04-17-2011 , 07:22 AM

Re: Column NUMBERS accepting only a pre defined range of numbers - 04-17-2011 , 10:00 AM

Re: Column NUMBERS accepting only a pre defined range of numbers - 04-17-2011 , 10:38 AM

Re: Column NUMBERS accepting only a pre defined range of numbers - 04-18-2011 , 02:28 AM