I saw this question via Twitter not to long ago, and then it came up again in a brief conversation with +Bobby Curtis, and it was about running SQL scripts over HTTP. So if you are interested, here is a quick post on how to do just that.
For this “demo”, I’m using #SQLDev 4.0 because I like the application. Thanks +Jeff Smith . You can also use SQL Plus for this. Here is a simple example:
Connect to your database and execute the following
SELECT 2+2 as “Sum” from dual;
Simple enough right? Suppose you needed this powerful script, and you couldn’t remember it, or just didn’t feel like typing all of this again. Everyone’s been there before. Build your script library on your web site and reference it from there. Give it a try.
Now that I have done this, let’s see what happens. Open SQLDev and try this: (Check out this use of the floating windows feature in SQLDev).
Simply execute as you would any other, directing it to the “web address” of the desired script. Now as you can see, it may take a bit longer to execute: .002s (local) vs .004s (remote), but it works.
I haven’t tested this out on any DDL, but I suspect that if you have been granted the appropriate privileges on the database, they would work as well, and whether or not to do something like this at all …. well that is up to you. Enjoy!!