Hi, I just wrote a short blog on changing the expiring password behavior of Oracle12. I think most of these settings are valid for Oracle11 as well. The short blog was on resetting PASSWORD_LIFE_TIME...
Hi, Ever go to log into your test environment to get the “Password expires in 7 days”? Or, you have been on vacation/busy with something else and your test environment password expires? Just one of t...
Hi, This month is a continuation of the Bulk Binding PL/SQL technologies from Oracle from last month. Click here to review the Bulk Collect syntax in loading arrays very quickly with rows. This arti...
Hi, Code Analysis has been in Toad for a while now. If you are using a slightly older version of Toad, it might be called Code Review, found under the same menu path. Code Analysis gives you or your...
Hi, This month I’ll focus on a couple of PL/SQL performance tips that will include how to utilize collections to radically increase row processing and a simple but useful coding tip on the benefits an...
Hi, I’ve written a lot of articles on Oracle12 new features. This article will conclude the series with a list of miscellaneous new features for the various other tools like data pump, the scheduler,...
Hi, I have a lot of PL/SQL tips to share. Here’s a first installment—perhaps more to come! Tip #1 The first thing I encourage all to use is %TYPE and %ROWTYPE on your variable definitions. In yes...
Hi! This article will cover some useful tips in finding the root cause of your application performance issues. Some of these suggestions might be useful to enhance your help-desk solutions; others mi...
Hi, I’m still learn from other speakers! Last week, Quest sponsored a Toad Maven seminar event downtown Chicago. I did an Advanced Indexing presentation and showed tuning topics in Toad. Watch for ...
Hi, I just wrote an article (click here to see article) that illustrates how B-Tree indexes work. Basically, they store key values that are to be looked up in their associated table. So, key values ...
Hi, SQL Injection is the unwanted addition of “other” logic into the database via the SQL language. Malicious attacks pass additional syntax either in hopes of gaining additional information (lets th...
Hi, I have written fourteen published books. I have self-published three additional books. This article will discuss some practical steps on how to go about writing books through a publisher and pub...
