I have a table that has a collection type for one field.
Create Type Tms_DCS as table of varchar2(100);
-- Create table
create table STORE_PROCESSING_EXCEPTIONS
(
run_date_exception date default on null sysdate not null,
dcs_running_exception_date tMS_DCS,
run_date_num_exception number
)
nested table dcs_running_exception_date store as TMS_DCS_EXCEPTION_DATE_TAB2;
I can do this in TOAD. I know this is a different product, but I think this is possible.
I have the following query to update the values:
Select rowid, A.* from store_processing_exceptions a;
I ran the query, Open the lock icon. I am able to update any field, but the dcs_running_exception_date.
I click the collection field after opening the lock icon. It opens a new table with only the values inside the collection. The lock icon in the collection tab is grey out.
I can do it with an update statement, but I thought this will be trivial using the PLSQL developer functionality.
[video:youtube]
https://i.imgur.com/tT9uwGj.mp4[/video]