I’m one of those types that always needs a project. If I run out of projects using the things I know, I take on a project that involves something I don’t know whatsoever. For instance, building a filesystem in C that connects to Oracle and uses queries in order to
Tag: Oracle
Easy Stored Procedure Output
I answered a question on a DBA Forum today and I thought it was a common enough question to warrant a blog posting. Question: I am new to the wonderful world of Oracle. I want to be able to view the results of a stored procedure in an output window,
Make History with Streams
Oracle Streams is an outstanding way to get data from one server to another. It is NOTHING like the advanced replication of old, which is why I call it “outstanding” and not “horribly inefficient and error-prone, not to mention annoying.” Recently I was asked how to implement a custom INSERT
Do Frequent Commits Fix ORA-01555?
I answered a question on the OTN forum this morning that I figured is pertinent enough to post on my blog…it’s a very common question among DBAs and developers, and I think there are plenty of myths surrounding it as well. Question: I am updating 1 million rows in Oracle