title: Oracle SQL: select from table with nested table
body: <p>I wonder how can i make select statement from table which have a typed column ?
  Type of this column is defined as:</p>
  
  <pre><code>create or replace TYPE "MYCOL" as table of MYTYPE; 
  create or replace TYPE "MYTYPE" as OBJECT
  ( myid Number, myname Varchar2);
  </code></pre>
  
  <p><strong>UPD1</strong>
  Table is defined as </p>
  
  <pre><code>CREATE TABLE "T_TABLE" 
     (    "ID" NUMBER NOT NULL ENABLE, "NAME" "MYCOL" )
  </code></pre>
  
  <p>If i select this column with <code>select * from T_TABLE</code>  i will get this not informative result:</p>
  
  <pre><code>1, MYSCHEMA.MYCOL([MYSCHEMA.MYTYPE],[MYSCHEMA.MYTYPE])
  </code></pre>
  
  <p>I want just to unwrap this types.</p>