|
Run your Oracle
query from your IE8 browser. Just copy it into your clipboard
first.
Browser Query
Runner-MultiDb
|
It doesn't matter it is a query
from the web or your file - if you can copy it to your
clipboard you can run it from your browser in just 2 steps.
And run it on one or a thousand-and-one databases! Here
is how.
Windows Xp;
IE8 |
 |
Step 1:
Download and
install Bqr1001
Download Bqr1001.zip and
extract all files to a temporary directory on your
hard disk. Double click on the BrowserQueryRunner.install.bat to
copy files and create registry entries, create a shortcut to
the readme.txt file from the start menu and open up the
ConnectStrings.txt file with some sample entries.Modify the
username, password and database instance name in this file in as
below.
system manager xe
system manager xe as
sysdba
Make sure to keep only the the username,
password and database information with no empty lines on top or
bottom or any comment lines anywhere. Save and exit.
Step 2:
Configure IE8 Command
Bar
At the end of the install Bqr1001 starts a new
IE8 window. Make sure to enable the command bar from
Menu-View-Toolbars-Commandbar.
|
|
|
CommandBar |
Customize |
ReorderWithSprts |
|
|
|
|
|
|
|
Close all IE8 windows. Open a new IE8
window.
Click on View
from File Menu.
Select
Toolbars and then make sure Command Bar is
selected.
Right Click on the
Command Bar and select Customize and then Add
Remove Commands.
Select
Seperator, BqrEdit, BqrRun,
Seperator from the leftside and click the
Add-> button to move them to the right one by
one.
Now Click on the
BqrEdit button from the IE8 Commandbar.
Bqr1001 opens up a
notepad window
with some sample queries. Save these or your own query and
exit.
Press the BqrRun button and the
Bqr1001-MultiDb hta window opens up.
The query saved from the
IE8commandbar-BqrEdit can be viewed by pressing the ViewScript
button here on the left side.
After checking the query, press the
user@db_RunScript links to run the same query on any database.
The browser is primitive and has limited
functionality but can be used to view the
BrowserQueryRunner.htm and other relevant pages on sqlhtm.com.
You can also search for a query from the web using google and
run it using ClipRunRightClick from here itself if you have
installed Crrc! Pull the frame borders on the left and right
panels to resize them.
If the runner runs too long, remove
stray sqlplus.exe, cmd.exe and mshta.exe processes from the
task manager and restart Bqr, because user inputs with &,
missing / or ; and spool commands freeze Bqr. Try logging out
and relogging or reinstalling BQR1001 if needed.
|
SEARCH AND RUN ONE OR MORE WEB
QUERIES:
|
|
Search/
View/Qry[ies] |
OpenPage |
CopyQuery/
Queries |
BqrEdit |
Save |
BqrRun |
MultiDbView |
MultiDbView2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Open a web page with Oracle queries from the
internet.
Select a query[or queries] that ends with a
semicolon[;] or slash[/] and copy the query[or
queries].
Click on BqrEdit from the Command Bar and
paste your query, save and click on BqrRun on the command bar to run
and view the result.
RUN ONE, SOME OR ALL QUERIES FROM A LOCAL FILE ON THE PC:
|
|
|
|
Enable
CommandBar |
Open
Script |
Open
Script |
CopyQuery/
Queries |
BqrEdit |
Save |
BqrRun |
Output |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
Open a local file on your pc with IE8, copy one or more
queries, click on BqrEdit on the command bar, paste the
query into notepad, save it and press BqrRun from command bar
to run and view
it. |
|
Remember to change the ConnectStrings.txt file as
needed.
Remember to keep the IE8 COMMAND TOOLBAR [
View-Toolbars-CommandBar] enabled, otherwise the BqrEdit and
BqrRun buttons won't show in the IE8 command
bar.
IMPORTANT: IT IS ABSOLUTELY ESSENTIAL TO CONNECT TO
THE CORRECT DATABASE AS THE CORRECT USER!!!. |
 |
ADDING
AND REMOVING USERNAME,PASSWORD AND DATABASE
INFO:
To add/modify/delete username,password and
database information, make the changes
in the
C:\Sqlhtm\Bqr1001\ConnectStrings.txt file in the form:
username password
dbinstance
or
sys password dbinstance as
sysdba
Example:
system manager xe
sys manager
xe as sysdba
and restart Bqr1001.
UNINSTALL:
If you want to uninstall Bqr1001, run
BrowserQueryRunner.uninstall.bat from where you unzipped the zip
file.
DEBUGGING
TIPS:
-Remember to open a new IE8 browser and enable
the command bar from
Menu-View-
Toolbars-Commandbar.
-Make sure to comment
out spool commands in the queries.
-Make sure the queries end
with a / or ;
-Remove stray cmd.exe, sqlplus.exe and mshta.exe
processes from the task manager
if there is a problem. Try
logging out and re-logging if needed.
-Uninstall and reinstall
Bqr any time.
| 