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

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.

--
Sybrand Bakker, Senior Oracle DBA