Re: negative number specification in datatype?

Hi,
Use CHECK constraint.
ALTER TABLE EMP ADD CONSTRAINT
  sal_chk CHECK (SAL >=0);

AMARENDRA
 Oracle DBA

Jackie A. Marino wrote:

> Is there a way in Oracle when creating a table to specify that a number
> column cannot be negative, Sybase has this ability. OR should I just
> create a constraint or script?
>
> Thanks for your help.
>
> jam.

--
*****************************************************************
AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:
-----------
5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656


Ph.No. (708) 583 9870 (H)
       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************
Opinions are mine and do not necessarily reflect those
of Whittman-hart Inc.