Simple Object For Extracting Oracle DDL Statements

stractor.rb

require 'oci8'

class Stractor
  
  def initialize( db_user, db_password, db_name )
    
    @db_user = db_user
    @db_password = db_password
    @db_name = db_name
    
  end

  def extract_ddl( object_type, object_name )
  
    ddl_sql = %q{
    SELECT dbms_metadata.get_ddl( :object_type, :object_name ) ddl_clob FROM dual
    }
    
    db_connection = OCI8.new( @db_user, @db_password, @db_name )
    
    ddl = ""
    
    db_connection.exec( ddl_sql, object_type, object_name ) do |result|
      ddl << result[0].read
    end
    
    db_connection.logoff
    
    return ddl.delete( 34.chr ).gsub( Regexp.new( @db_user << '\.' ), '' ).strip << ";"
    
  end
  
  def extract_into_file( object_type, object_name, file_name )
  
    ddl = extract_ddl( object_type, object_name )
    File.open(file_name, 'w') {|f| f.write( ddl )}
  
  end
      
end