This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'll be storing an array of strings. I know I can simply store a delimted string in a regular varchar field then use StringTokenizer. But storing an array sounded interesting. If coding the storage of array is a really big effort I will probably go the StringTokenizer way. I just wanted to give it one last chance before giving up. Thanks.
Oracle has support for collections. It's very much possible to store the array/collections. You have two options 1. Create new types in oracle and change your JDBC calls to use Oracle specific classes. This might be big effort based on your need. 2. Create new types in oracle and use stored procedure to do all DML and Select.