SA-DBA:

SQL Script

1

July 14, 2009  1:40 PM

Environmental consistency .. is that even a real phrase?



Posted by: Richard Evans
alias, export, kshrc, profil, shortcut, SQL, SQL Script, SQLPATH, SQLPLUS

Whether it is or isn't doesn't really matter... what I mean by environmental consistency is basically just making your life easier by installing, configuring, testing, developing, etc, the same way. This is one of the reasons why I love Response Files in Oracle. Another thing we do pretty well...

July 10, 2009  12:04 AM

Grid Control Job to Excel Worksheet



Posted by: Richard Evans
Excel, GC, job, microsoft, reporting, SQL Script

Often times I'm asked to run a report that requires querying multiple databases. I suppose I could just setup DB Links and use a UNION ALL but why, when I have Grid Control? :-) First thing I do is setup a SQL Script job in Grid Control that looks like this. In addition to the user...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: