-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
rajkamal bhardwaj writes:
> Hi,
> I am using oracle 10g and is working with PL SQL. I write many programs and
> have lots of .sql files, .spc, .inc files. Sadly i had to run all of them
> one by one manually to finally arive at my file and then run it to get the
> result. Please can anyone help with the solution if I can make one file like
> we make bat files from where i can run all files sequencially ?
> For example how can create one .sql file such that:
> begin
> @abc1.sql
> @abc.spc
> @xzy1.sql
> and so on
> END;
I never used Oracle software, so assuming that its SQL client works something
like "oracle ${USER} ${PASSWORD} ${SQLSCRIPT}" and you have all your scripts
in same directory ending with .sql extension, then with Bourne (or compatible)
shells you can do:
$ for i in *.sql; do oracle ${USER} ${PASSWORD} $i ; done
OR if you like to concatenate all .sql files, then:
$ cat file1.sql file2.sql .... >>../big.sql
HTH
- --
Ashish SHUKLA
“There are two major products that come out of Berkeley: LSD and
UNIX. We don't believe this to be a coincidence.” (Jeremy S. Anderson)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (FreeBSD)
iQIcBAEBCgAGBQJOfIioAAoJEMdGz6nnT6SweJAQAKhBQegCbaivltMGAiZ71HLW
j1aWtiPErZF+2zg/MFLpN0vBYjVS2Td6splRb0vn5mpF2E2iIHjBAVEVn6IcJDK7
70D7I+IEJreQT/4Y5CA2nj5m5XiBq/Mir+TQoVzqq9nNKtHaw/knZ/9LEtOhtDIT
LRCA9MvmarTsTRxTjo6zVT1lWZGGvv/wJb9ecRgnHt4txGOChhw6L0sIPX9WMY9U
M40LR7CI9PswgXa0sxACST0I33vYlWUl+8xpNLzEXNEGdjbQ0+lwRHiORWicalbt
E44Y2hBj1ep926BB/x4RI77vJotlR2/VD1PW3m09A5HPoQjDC89dE5xY5q10oW+Q
4XBoPKuQLu27ZFZgEKtkPq/+Vl3r49q/M4rl+m1he1zpTe4z/F92WAbUWb1yDGHm
ZjdTR7FRFxv7dXrW9bUWcu1in2D6Y91aEOAxeij1vzkV4a6GPlFdCaCmHLcD7FVu
5w5Y4VPT7J2LC8TRr49p2/OrN/uS8kj7lvgZ9fn4wpfDf12GiSJOIHOovv2mMG2U
8SYUhXGwMsBt4phPjqZvM91xyAZ6y70sznE6J8GFV2p4yodlhnDYJ/Ue9uh+gULk
YZ9QquI+pb5emJjq1qPn0FUUS0Iioij0OUh0ZJueQPIl1INz4MaSQAUCNtqzupGY
2nQOiZ0hawCJdb/hAMeJ
=/abY
-----END PGP SIGNATURE-----
_______________________________________________
Ilugd mailing list
[email protected]
http://frodo.hserus.net/mailman/listinfo/ilugd
