Re: retrieve enum values
A more concise way is to use the INFORMATION_SCHEMA to grab the COLUMN_TYPE, which you would then have to parse/split to gather values from:
SELECT COLUMN_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'YourDatabase'
AND TABLE_NAME = 'YourTable'
AND COLUMN_NAME = 'YourEnum'
COLUMN_TYPE
-----------------
enum('A','B','C','D')
Subject
Written By
Posted
Re: retrieve enum values
January 06, 2008 12:45PM
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.