The Oracle Magazine Archive

Selected blog entries from Tom's blog, which are linked to from within the AskTom question repository

As database technology changes so rapidly, some of the content here is out of date, or less applicable to the current versions of the database, or just plain wrong! However, rather than erase that historical content, we've captured a selection of posts here on this page, because they still provide excellent technical content on the database versions of the time, and many of the principles covered are still equally relevant today.

We merely ask that you take this into consideration when reading the posts. Any recommendations you see in them should be carefully considered and tested before implementing in your own applications. It is quite possible that better options exist in more recent versions of the database. With that caveat covered, please enjoy the posts below.

• 12c - Code Based Access Control (CBAC) part 1
• 12c - Utl_Call_Stack
• 12c - Whitelists
• All about Security - SQL Injection redux
• All about Security - SQL Injection
• Another 'question of the day'
• Archive Log Mode
• Asktom Redux.
• Back from Oracle OpenWorld
• Back from a time out
• The Birth of Asktom
• Bits and Bytes
• The Book
• Building a better Website and Logic
• Classic example of why I despise
• Constraints have a bad name
• CSV
• Ctime
• DateDiff
• A day in the life
• DIY AskTom
• Doctors
• Download part of the new book
• The dreaded "when others then null" strikes again
• Evaluating an expression, like a calculator
• Evolution
• First there was
• Flash Forward
• Free
• Gripe Sheet
• They did not even mention variable
• How can I
• How cool is this
• How to ask questions
• How to give an answer
• http://asktom.oracle.com/tkyte/
• http://asktom.oracle.com/tkyte/flat
• http://asktom.oracle.com/tkyte/hexdec
• http://asktom.oracle.com/tkyte/unindex
• I am back
• I believe strongly there are only two answers
• I like online communities
• I'm not a DBA anymore
• IM Speak.
• Instrumentation
• An interview question
• It has been a while
• Large strings
• Messed up big time
• Motivation
• Move longs
• Mull about Null
• A new book on APEX coming out
• A new thing about sql*plus
• Next Book, Part II
• Next Book
• NLS date format
• NO_DATA_NEEDED - something I learned recently
• OCI N Tier
• Ok, so what happened up there on stage
• OOW - The presentation is done
• Order in the court!
• Ouch, that hurts
• Part II Seeing a Restart
• Part III Why Is a Restart Important to Us?
• Passwords
• Podcast and a quick video
• Podcast from OOW 2008
• Pokemon and When Others
• The Question of the day
• Question
• Random
• Random again
• A rant for today
• Raptor has arrived
• A reader asks
• Roles and procedures
• Security via obscurity
• See, you just cannot make this stuff up
• Slow by Slow
• So what was the answer, Part II
• So what was the answer, part III
• Something about nothing
• Something Different Part I of III
• Something I recently unlearned
• Something new I learned about estimated cardinalities
• Something new I learned this week
• Spell a number
• SQL
• Sql_trace=true, Part Two
• Stuck in a rut
• SU
• Success
• That old restart problem again
• The keys to Oracle
• This should be fun to watch
• This site owes me a new monitor!
• A tiny challenge
• Tuning with sql_trace=true
• Use NULL for unknown data
• Varying in lists
• What about Mathematics.
• What attributes
• What did I decide on
• What the heck do you do
• What I learned about deadlines
• What I learned new about Total Recall
• What is your FizzBuzz factor
• When the explanation does not sound quite right
• when others then null, redux
• Why the command line rocks
• Why do people do this?
• Why
• Worst Practices