Q: SQL*Plus Allowable Values?

From: Justin Wigg <jjwigg_at_tassie.net.au>
Date: 1997/11/26
Message-ID: <347BCC96.29B8@tassie.net.au>#1/1

Hi all,

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 ????????????) 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 CST