title: Displaying max() value of table that has nested table column
body: <p>lets say I have a nested table called test:</p>
  
  <pre><code>create table test(
       id int,
       name varchar2(20),
       production row_type_value,
       constraint pk_country primary_key(id)
  ) nested table production store as country_production;
  </code></pre>
  
  <p>the types are:</p>
  
  <pre><code>    create or replace type type_value as OBJECT(
          year int,
          value int
      );
      /
      create or replace type row_type_value as table of type_value;
  </code></pre>
  
  <p>there is a way to just in one query get the max(value) of the production column of all countries given a year for example?  </p>