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
dusoo
Messages: 41
Registered: March 2007
Member
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?
thanks

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

values
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: 64140
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.

Regards
Michel

Previous Topic: How to avoid parallel updates on a table in a procedure.
Next Topic: Need advice on optimizing Update statement
Goto Forum:
  


Current Time: Fri Dec 09 05:35:20 CST 2016

Total time taken to generate the page: 0.17625 seconds