Re: Q: SQL*Plus Allowable Values?
From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/11/26
Message-ID: <19971126232601.SAA09067_at_ladder01.news.aol.com>#1/1
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
Received on Wed Nov 26 1997 - 00:00:00 CET
Date: 1997/11/26
Message-ID: <19971126232601.SAA09067_at_ladder01.news.aol.com>#1/1
>ALTER TABLE table_name
>MODIFY (ADD CONSTRAINT ????????????)
>
>I cannot figure out what to put in the ?????'s.
alter table junk
add check (junk_type IN ('SCRAP','GARBAGE'))
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
Received on Wed Nov 26 1997 - 00:00:00 CET