Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE OR REPLACE TYPE CHAR_TAB_20_TYPE IS TABLE OF VARCHAR2 (20);
CREATE TABLE table_1 (
  selection_id VARCHAR2(4),
  col_1        VARCHAR2(3),
  order_consignee_tab CHAR_TAB_20_TYPE
) NESTED TABLE order_consignee_tab STORE AS table_1__order_consignee_tab;
INSERT INTO table_1 (selection_id, col_1, order_consignee_tab)
VALUES ('TEST', '206', CHAR_TAB_20_TYPE('ABC', 'DEF', 'GHI'));
1 rows affected

SELECT selection_id,
       order_consignee_tab
  FROM table_1
 WHERE col_1 = '206' AND selection_id = 'TEST';
SELECT selection_id,
       o.COLUMN_VALUE AS order_consignee
FROM   table_1 t
       CROSS JOIN TABLE(t.order_consignee_tab) o
WHERE  col_1 = '206'
AND    selection_id = 'TEST';


SELECTION_ID
ORDER_CONSIGNEE


TEST
ABC

TEST
DEF

TEST
GHI