@ext

The ext script will do a source extract of all found database objects.  It will extract the source for these object types:  

  • Package
  • Package body
  • Procedure
  • Function
  • Table
  • Sequence
  • Trigger
  • View
  • Index
  • Synonym

  Installation: Create two new directories named “extract” and “source” in your sql working directory. Unzip all files to the “extract” directory. Move the ext.sql file to your working directory.   Syntax: @ext <partial object name>  

Download: sql4oracle.zip - all sql4oracle scripts - posted 14-03-2013

Leave a Reply