Category: Technical

A Little Fun for Today

As an I.T. professional, I get some, um, shall I say random questions from time to time. This one came this morning on my IM. (Instant Messenger) Coworker: STUPID QUESTION TIME- is there a way top make my keyboard silent? Me:...

Read More

Avoid ORA-00054: resource busy and acquire with NOWAIT specified on Truncate

If you are an Oracle programmer, then you’ve probably encountered the ORA-00054: resource busy and acquire with NOWAIT specified exception when attempting to truncate a table. When this happens during the day, you can usually just wait a few minutes (or go and commit your other open sessions…), but what about when you are truncating tables as part of a script which runs overnight? Are you tired of being woken up so you can simply rerun the script?

Well check out this script, then! It is a very simple PL/SQL procedure which accepts 1 or 2 arguments.

Read More

Delete duplicates in Excel

Once in a while I want to write an article on technology. Here is the first one.

Have you ever had a large dataset (or small) that you imported into Excel somehow and you just want to remove all the rows that duplicate on a certain column? Here’s a couple quick macros you can use to solve your problem. Just copy and paste this code into a module in Excel VBA and run them like any other macro.

Read More
Loading