Need help with a simple srcipt

[dtalex]

Hi all
can you please help me converting thi simple script from bash to batch?

Code: Select all

for element in `ls | grep .sql` 
do
   cat $element >> scriptino.sql
done

I just want to put the output of all .sql files in a directory
in anoither sql file in the same directory

Thank you

[dbenham]

Everything below assumes you are running the command or script from the directory with the .sql files, as does your script.

From the command line:

Code: Select all

(for %f in (*.sql) do type "%f")>scripino.sql

Within a script (.bat or .cmd file)

Code: Select all

(for %%f in (*.sql) do type "%%f")>scripino.sql

Both the above will include the TYPE command with filename above each file contents. If you only want the file contents then we need to disable the echoing of the command:

from command line:

Code: Select all

(for %f in (*.sql) do @type "%f")>scripino.sql

Within a script:

Code: Select all

@echo off
(for %%f in (*.sql) do type "%%f")>scripino.sql

Dave Benham

[dtalex]

Thank you Dave

Everything below assumes you are running the command or script from the directory with the .sql files, as does your script.

What I want to to is just double click on it (already placed in the directory i'm intrested) and run the output file in sql developer ('/' are already included in sql files)