(Rudy Limeback) I need to compare one field in my table against an entire column in another table. The second table has a list of excluded codes that do not need to be in the first table. How would I go about doing this? (R)

(Mark Brunelli) One of the biggest challenges facing Oracle technology professionals today is dealing with upgrades, and as companies gear up for the next major upgrade cycle, IT industry experts and Oracle customers say there are some best practices to remember that can ease upgrade pains. (R)

(John) Do you fret every time you declare a PL/SQL variable, that you’ve carelessly allocated a few unnecessary bytes, and that this wastage will be replicated thousands of times as your code is called from a bazillion sessions, and that that will be the straw that breaks the camel’s back and makes

(Marco Gralike) Hate? Let’s say it is a love / hate thing, but I can’t help myself. I am a script nerd and probably always will be, but even I have to “evolve” or at least adapt to what the new software cycle brings. So preparing myself for the future, I based remote administration on Oracle Ent

(Paul Moen) So you have followed the recipes to create a standby database, setup the database to switch logs automatically, and now, as with any good database, the space required to support the application grows and grows and grows.

(Avanish Srivatsav) Keeping database packages in the Oracle database’s System Global Area (SGA) shared pool is a common practice. This is also called pinning. One common misconception is that pinning is not useful or needed in later Oracle database versions such as 10g and above, since those relea

(Bob Watkins) Oracle’s Export utility (exp) is a useful part of an overall backup strategy. It allows you to restore as little as a single table, which is something that’s difficult to do with regular datafile-based backups. But as databases and individual tables have grown in size, it’s become diff

(James F. Koopmann) Read on and learn how to set the module and action names.

(Vivek Sharma) There’s a lot of debate about the usage of Prefixed and Non Prefixed Local Indexes. I have come across a misconception many dba’s have about these indexes when it comes to performance.

(Andrejus Baranovskis) Recently I was researching Google Analytics data for my blog. I have noticed, that there are many search engine keywords with ‘ExecuteWithParams’ word. Really, this action plays one of the central roles in Oracle ADF BC application, it is used quite frequently and people want