title: Oracle 11g VARRAY of OBJECTS
body: <p>I have the following statements in Oracle 11g:</p>
  
  <pre><code>CREATE TYPE person AS OBJECT (
      name VARCHAR2(10),
      age NUMBER
  );
  
  CREATE TYPE person_varray AS VARRAY(5) OF person;
  
  CREATE TABLE people (
      somePeople person_varray
  )
  </code></pre>
  
  <p>How can i select the name value for a person i.e.   </p>
  
  <pre><code>SELECT somePeople(person(name)) FROM people
  </code></pre>
  
  <p>Thanks </p>