title: generate database & tables schema (ddl) on Oracle pl-sql
body: <p>Anyone have a PL-SQL statement that i can use to generate database &amp; tables schema for specific database on Oracle 10g? I need the schema in .sql file and if possible compatible with ANSI-92/99 sql implementation, so i can use the generated .sql directly on sql server 2005.</p>
  
  <p>Already heard about exp/imp, but it seems generated dump file, what i need just a simple ddl on .sql file.</p>
  
  <p>Thanks</p>