How to Alter Table column to Collection in PL/SQL?

Question

I want to store value in column of table as list (Nested Table or Table).
How can i do it ?
Thank for your help !
I'm use Oracle Database (PL/SQL) and my IDE is SQL developer.

Do you specifically need to alter an existing column to make it into a collection, or are you just looking for the [syntax to add a column](http://docs.oracle.com/database/121/SQLRF/statements_3001.htm#i2183462) of type [nested table](http://docs.oracle.com/database/121/SQLRF/statements_3001.htm#i2103531)? — William Robertson, Mar 13 '17 at 15:22

score 0 · Answer 1 · answered Mar 13 '17 at 04:08

You can refer below snippet to add nested table column in Oracle table. Hope this helps.

CREATE OR REPLACE type number_ntt
IS
  TABLE OF NUMBER;

CREATE TABLE WITH_NESTED_COL
  (
    SR NUMBER,
    NUM_TAB NUMBER_NTT
  )
  nested table NUM_TAB store as NUMBER_TYPE;

How to Alter Table column to Collection in PL/SQL?

1 Answers1