Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to split a data definition SQL script file (DDL script)

Re: How to split a data definition SQL script file (DDL script)

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 16 Sep 2006 15:18:37 -0700
Message-ID: <1158445117.521776.212490@m73g2000cwd.googlegroups.com>


Sybrand Bakker wrote:
> On Sat, 16 Sep 2006 21:22:21 +0200, Seb <arx9qekubvq93e3_at_jetabe.net>
> wrote:
>
> >Hello,
> >
> >I need to split a Oracle data definition SQL script file (DDL script) to
> >many files, each file corresponding to one command category (table
> >creation, constraint creation, index creation, etc).
> >Do you know some tool to do that ?
> >
> >Thanks in advance for your answers !
>
>
> awk, vi and sed come to mind. If you are on Windows, gvim is a vi
> clone for Windows, www.gvim.org If you need awk and sed too you can
> download Cygwin, which is (korn)shell clone for Windows.
>
> And then of course Perl could do it.
>

Perl! Perl! Perl! :-) (Is there anything you can't use it for?) But then again, not meaning to be rude to the OP, someone asking this question will probably not be able to make Perl do it.

cheers,
Martin

p.s.: I agree that this post was not really helpful. Received on Sat Sep 16 2006 - 17:18:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US