developer – Page 2 – Learning is not a spectator sport

Get the SQL_ID for a SQL statement BEFORE you run it

An AskTom customer asked the question recently: “We often use the SQL_ID to dig into the performance views once we

A friend threw me a puzzle yesterday which I thought would be challenging, but turned out to be easy to

Hopefully by now you have seen the buzz about the release of 21c Express Edition (XE) and here’s a walkthrough

If you’re an Oracle developer, pause for a second and ponder this question: What is the most important skill you

(Familiar with case-insenstive collation already? Skip ahead to the “Side Effects”) A history of failed applications Before Oracle 12, a

I’m a developer. I wrote code, compile code, and ….. then I throw it over the fence to the testers

Oracle dinosaurs whoops I mean “experienced professionals” know that for decades we have used the DBMS_UTILITY package to obtain the

I gave a talk at Kscope21 yesterday about common mistakes that we make during the database development cycle. To kick

Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a

One of the most common recommendations I’ll make to customers who post questions on AskTom is “Install APEX even if