Home » SQL & PL/SQL » SQL & PL/SQL » column as a collection
column as a collection [message #272455] Fri, 05 October 2007 02:04 Go to next message
Messages: 41
Registered: March 2007
Hi everyone.

i have a table where i'd like to add a new column where i could store email rcpt list. Dont want to have it as varchar2, because i would have to substring it to get the needed values.
Is there a way to create this kind of column without rebuilding the whole table?

table extract
(exs_id number,exs_desc varchar2, mail_list collection)

exs_id 1
exs_desc finance
mail_list 'tomtom@tomtom.com','asdf@asdf.com'

select mail_list(1) from extract;
=> 'tomtom@tomtom.com'

Re: column as a collection [message #272456 is a reply to message #272455] Fri, 05 October 2007 02:15 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Go to
Application Developer's Guide - Fundamentals
PL/SQL User's Guide and Reference
and search for collection.


Previous Topic: ORA-00902: invalid datatype
Next Topic: Problem with password
Goto Forum:

Current Time: Tue Aug 22 23:26:19 CDT 2017

Total time taken to generate the page: 0.04368 seconds