database tools, oracle, sql server, db2, monitor, monitoring, performance
home
who are we
products
database product monitor
database product reorg
database product capacity planning
external alerting device
sharepoint products
sharepoint products hour reporting
customers
partners
links
competition us and them
oracle dba scripts
contact us
our mail list
[ Jan, 2008 ]
B.G.S Software products are becoming popular in china. (See Brochure)

[ Jan, 2008 ]
We have a BLOG for feedbacks and information sharing. (Visit our blog)

[ Oct, 2006 ]
Capacity Planning Package for Oracle Database is now included in the monitor!. More...

[ Jul, 2006 ]
Build a package of the monitor especially to monitor your application and database. Provide a monitoring tool 'built in' in your product. More...

[ Jul, 2006 ]
New object called "History Keeper" was added to the monitor. This object allows saving history of the monitor into a repository in the database.
It's possible to define the frequency of saving a sample, and the number of days to keep in the repository.

[ Jun, 2006 ]
New electronic equipment called "External alerting device" (made by B.G.S.) was added to the monitor.
The device connects to the PC's parallel port and can activate a siren & light alert (wired or wireless). It's possible to define thresholds and statuses to activate the alert.

Oracle Database Scripts


Flip a table on the side (SQL Trick):


The Script:


SQL:

Select name, value from tbl;

Results:

NameValue
Param110
Param120
Param130

Flip Table SQL:

select max(decode(name,'Param1',value,'')) Param1,
   max(decode(name,'Param2',value,'')) Param2,
   max(decode(name,'Param3',value,'')) Param3
   from tbl;

Results:

Param1Param2Param3
102030


Donate 5$

If you found this information useful, don't be cheap, donate 5 dollars (with PayPal):