Category Archives: Uncategorized

Selecting rows when the data does not exist

This just came up again at a job. The customer needs to select a month worth of results for a particular object in their system, but the data does not exist for a whole month. Even if it doesn’t they need to show a row for it. So here is how you can Select rows when the data does not exist

Advertisements

Taking care of your computer (Windows)

I’ve created this page for my family, so they don’t have to remember what to do. If you don’t do these things you really should. Please click here…

A simple Oracle Point-In-Time Recovery

As stated, a nice simple example of Oracle Point-In-Time recovery…

Re-create user SQL script

The following is a script I created to generate a script to recreate specific users from a database, so they can be created elsewhere. I typically use this for end-users who do not have schemas. Read here Re-create user SQL script

Oracle Logon Logoff functionality

The Oracle auditing functionality does not always give you everything you want, or as easily as you want it.
This is a script I created that produces a user logon/logoff tracking system in your Oracle database.

Read more here…

Oracle lsnrctl start = Linux Error: 13: Permission denied, lsnrctl status = Linux Error: 111: Connection refused

Another really annoying problem. I checked all the “normal” things and they were fine. It was a problem with a hidden directory and Oracle doesn’t tell you what file, just the error.  Read the article to find the fix.

INS-30516 Please specify unique disk groups

When I hit this problem I did some searching and found the same solutions, but none with the trick that I needed. While they present how to solve the problem, the trick in my case was in how the problem was actually created.

Read more …