title: Oracle - using nested table column in where clause
body: <p>I have a staging table (table_B) with columns using nested table data types:</p>
  
  <pre><code>CREATE OR REPLACE TYPE nested_column_type AS OBJECT
            (
              abc_1            VARCHAR2(100),
              abc_2            VARCHAR2(100),
              col_id           VARCHAR2(100),
              tbl_id           NUMBER
            );
  
  CREATE OR REPLACE TYPE nested_column_tab AS TABLE OF nested_column_type;
  
  CREATE TABLE table_B
  (col_id NUMBER,
   nested_column NESTED_COLUMN_TAB)
  NESTED TABLE nested_column STORE AS column_nested);
  </code></pre>
  
  <p>I want to use nested_column in the where clause of a delete statement like this:</p>
  
  <pre><code>DELETE FROM table_A a
  WHERE tbl_id = v_tbl_id
  AND NOT EXISTS (SELECT col_id 
                    FROM TABLE(SELECT b.nested_column 
                                 FROM table_B b 
                                WHERE tbl_id = v_tbl_id) 
                   WHERE col_id = a.col_id);
  </code></pre>
  
  <p>Table_A is my target table. My goal is to delete records from table_A where table_A.col_id NOT EXISTS in table_B.nested_column.col_id and tbl_id = v_tbl_id.</p>