select query
Posted by:
Dah Chang
Date: February 15, 2012 04:11PM
Table t has column name colors varchar();
colors must be in of list of ('red', 'green', 'blue')
select * from t where colors='black';
return empty
Is there any way to issue warning or error 'black' is not in the list?
dah
Subject
Written By
Posted
select query
February 15, 2012 04:11PM
February 16, 2012 10:19PM
February 17, 2012 10:48AM
February 18, 2012 06:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.