How can I get information about a data type set
2 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   hui_zou
Posted On:   Sunday, November 11, 2001 04:09 PM

If the data type of one column in the table is set, How can I know how many elements and what elements in it by meta data method?

Thanks

Report | Quote This | Send private message | Reply | Print

Re: How can I get information about a data type set

Posted By:   Peter_Karlsson  
Posted On:   Friday, November 16, 2001 05:34 AM

You can do a "select distinct column from table", this will give you a list of different values in the column (hope I understand you question).
Report | Quote This | Send private message | Reply | Print

Re: How can I get information about a data type set

Posted By:   Bozidar_Dangubic  
Posted On:   Sunday, November 11, 2001 07:20 PM

load it into java.util.Set and call size() method on it. there is no metadata method that will tell you that, but if you get it out of the result set and into Set, you can figure it out.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact