Q: SQL*Plus Allowable Values?
From: Justin Wigg <jjwigg_at_tassie.net.au>
Date: 1997/11/26
Message-ID: <347BCBF7.1A0A_at_tassie.net.au>#1/1
Justin.Wigg_at_dpif.tas.gov.au (Work)
jjwigg_at_tassie.net.au (Home)
Received on Wed Nov 26 1997 - 00:00:00 CET
Date: 1997/11/26
Message-ID: <347BCBF7.1A0A_at_tassie.net.au>#1/1
Hi all,
[Quoted] Can someone please tell me how to add an allowable values constraint to a VARCHAR2 column in SQL*Plus? This newbie cannot figure it out...I have tried to work this:
ALTER TABLE table_name
MODIFY (ADD CONSTRAINT ????????????)
[Quoted] I cannot figure out what to put in the ?????'s.
Thanks for any help,
Justin.
Justin.Wigg_at_dpif.tas.gov.au (Work)
jjwigg_at_tassie.net.au (Home)
Opinions expressed are mine and not
values or opinions held by the DPIF
Received on Wed Nov 26 1997 - 00:00:00 CET