Every administrators, developers have their own collection of scripts (some patterns). Time to time they are dismissed from one job and they are employed to other one. Is there any good, easy used, indexed tool to collect the common used sql scripts (structured folder/file system as a default)?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I started to play with RedGate's tool - Script Manager. You can have them together in a single place with some UI. It may worth a try :).
In SQL*Plus, the Oracle command line too, you can use the syntax:
And run all your scripts off your own personal webserver if you like. My good friend Vishal does this. You just need to get a VM or something of your own, these are cheap now, a quick Google shows £10/month.
Just be certain it doesn't stipulate in your contract that your employer owns any scripts you write while working for them...