title: How to extract sequence ddl in Oracle DB
body: <p>I have a problem when try extract ddl for sequence using this function in this query:</p>
  
  <pre><code>select dbms_metadata.get_dependent_ddl('SEQUENCE', base_object_name) from dual;
  </code></pre>
  
  <p>base_object_name -  name of trigger, that use sequences.
  Result: <strong>ora-31604 invalid name parameter NAME "BASE_OBJECT_NAME" for OBJECT_TYPE 'SEQUENCE'</strong></p>
  
  <p>For example when I execute this query:</p>
  
  <pre><code>select dbms_metadata.get_dependent_ddl('INDEX', base_table_name) from dual;
  </code></pre>
  
  <p>in result I have indexes for specified table.</p>
  
  <p>Please, help, how to extract sequence ddl using <code>get_dependent_ddl()</code> function?</p>