title: How to get information about a User-Defined Type?
body: <p>In simplicity, PL/SQL generally follow the following:</p>
  
  <pre><code>DECLARE 
       Variable declaration
  BEGIN 
       Program Execution 
  EXCEPTION 
       Exception handling
  END;
  </code></pre>
  
  <p>I am quite new to PL/SQL and i am looking at the variable declaration section where i would like to find out more information on <code>SALES_PRODUCT_TY_LIST</code>. </p>
  
  <p>Is there a table i may look up to check on information on SALES_PRODUCT_TY_LIST, such as checking out table column information from all_tab_cols view?</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE GET_DISCOUNTS
  (
    v_have_list SALES_PRODUCT_TY_LIST
  )
  IS
    QUERY VARCHAR(5000);
  ...
  </code></pre>
  
  <p>Thanks.</p>