title: Extracting PL/SQL procedure DDL using SQL*Plus in Oracle?
body: <p>Is there a way to spool/extract/dump Oracle object's source DDL using only SQL*Plus?</p>
  
  <p>I'm aware of <code>dbms_metadata.get_ddl</code>. Can you give me an example of how it can be done in SQL*Plus without resorting to any scripting language?</p>
  
  <p>I assume that script will accepts object list or regexp and login string and result is a list of files on filesystem containing all the sources (one DDL per file).</p>