title: Need to update the ALTER TYPE object
body: <p>I have created  an <code>TYPE object</code> named <code>example1</code> using following query.</p>
  
  <pre><code>create or replace type example1 as  object
                            (emp_name varchar2(32)
                            ,emp_location varchar2(32)
                            )
  </code></pre>
  
  <p>Later I tried to change the length of the variable <code>emp_location</code> to    <code>varchar(36)</code>   and I tried multiple ways</p>
  
  <pre><code>ALTER TYPE Point ADD ATTRIBUTE emp_location varchar2(36) CASCADE;
  </code></pre>
  
  <p>and I end with the following object.             </p>
  
  <pre><code>create or replace type example1 as  object
                            (emp_name varchar2(32)
                            ,emp_location varchar2(32)
                            )
  
   Alter type example1 modify attribute emp_location varchar(36) cascade
   Alter type example1 modify attribute emp_location varchar2(37) cascade
   ALTER TYPE example1 DROP ATTRIBUTE emp_location INVALIDATE
   ALTER TYPE example1 ADD ATTRIBUTE emp_location varchar2(38) CASCADE
  </code></pre>
  
  <p>Now I want to remove the following  </p>
  
  <pre><code> Alter type example1 modify attribute emp_location varchar(36) cascade
   Alter type example1 modify attribute emp_location varchar2(37) cascade
   ALTER TYPE example1 DROP ATTRIBUTE emp_location INVALIDATE
   ALTER TYPE example1 ADD ATTRIBUTE emp_location varchar2(38) CASCADE
  </code></pre>
  
  <p>How can  I do that ? </p>