title: Deleting specific record from nested table Oracle DB
body: <p>I'm having problems deleting specific record from the table (ORACLE DB). 
  I have a table with a nested table inside of it.</p>
  
  <p>Table structure looks like this: where ML - nested table</p>
  
  <pre><code>Name, City, ML(Brand, Model, ID, Year, Price)
  </code></pre>
  
  <p>What I need to do is delete specific record with ID of 'L201'.</p>
  
  <p>What I have tried so far:</p>
  
  <pre><code>SELECT B.ID FROM TABLE Dock A, Table(A.ML) B;
  </code></pre>
  
  <p>This is working giving me all the ID's.</p>
  
  <p>Output:</p>
  
  <pre><code>ID
  ____
  B201
  S196
  L201
  </code></pre>
  
  <p>This is not working when trying to delete the record:</p>
  
  <pre><code>DELETE FROM Dock
  (SELECT B.ID FROM Dock A, Table(A.ML) B) C
  WHERE C.ID = 'L201';
  </code></pre>
  
  <p>Getting error:</p>
  
  <blockquote>
    <p>Line 2: SQL command not properly ended;</p>
  </blockquote>
  
  <pre><code>DELETE FROM TABLE
  (SELECT D.ML FROM Dock D) E
  WHERE E.ID = 'L201';
  </code></pre>
  
  <p>Throws an error:</p>
  
  <blockquote>
    <p>single-row subquery returns more than one row</p>
  </blockquote>