Learning is not a spectator sport

Where is my tracefile

As a developer, you might have have been reading about SQL trace. After all, we all want to be able

So a request comes in from a colleague… ”Hi Connor. I’ve created this new table, and I need to populate

Whenever you have the need to use the DISTINCT keyword, its worth just pausing for a second, and making sure

Can you make your SQL code easier to understand without adding comments. Can it be self-documenting ? Can you do

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives

If you head on over to http://docs.oracle.com/en/database/ you’ll be both amazed and dismayed by the volume of documentation you can

Last month I joined Oracle after nearly 20 years of working with their technology. Some people congratulated me on my

I did a “desc” command on the STANDARD package today, the package that helps define PL/SQL, and saw the XOR

You’ve been google-ing and you’ve seen articles (for example) like http://www.oracle.com/technetwork/articles/sql/11g-securefiles-084075.html and you’re pretty pumped about using SECUREFILE features. You’ve

“Continuous Delivery (CD) is a software engineering approach in which teams keep producing valuable software in short cycles and ensure