 | 4 May 17:18 Links to interesting, educational, informational, or just plain fun websites... 2 May 13:47 I almost forgot that the Oracle Joins series is not complete yet. So here is the last episode, a quick and easy anti-join and semi-join refresher. Anti-joins: Anti-joins are written using the NOT EXISTS or NOT IN constructs. An anti-join between two tables returns rows from the first table for which there are no corresponding rows in [... 30 Apr 15:02 Oracle PL/SQL has a neat and little known feature called forward declaration. In this post I'm going to do a quick review of what forward declaration is, how it can be used and a situation where forward declarations are absolutely required, mutual recursion. 27 Apr 12:56 Tom Johnson has a list of twenty usability tips for your blog. Does your blog follow these principles that distinguish good blogs from poor ones? I believe that mine does. Here is why. My blog: Has a tag line that clearly identifies the topic of the blog: News, views, tips and tricks on Oracle, ColdFusion and [... 23 Apr 13:26 It’s the season of stumbling: StumbleUpon, in its most recent toolbar, introduced a new feature called StumbleThru, which allows users to stumble through pages on a specific web site. Google introduced a recommendations button that you can add to the Google toolbar. The button looks like a pair of dice. Every time you click on the dice, [... 19 Apr 13:56 Here is Steven Feuerstein, the renowned Oracle PL/SQL guru, presenting “PL/SQL Best Practices, making the most of the of Oracle PL/SQL”: And here is another presentation by Steven titled “You Wrote What? an examination of common coding mistakes made by PL/SQL Developers and how you can avoid them”: Note: These videos are provided by Quest Software. You can [... 16 Apr 07:42 Please update your bookmarks and links. OraNA, the largest Oracle news and blogs aggregator, has a new home: OraNA.info. It also has a new look. The OraNA RSS feed, however, is still the same. If your blog is aggregated by OraNA, you can grab the HTML code from here to easily place the “Aggregated by [... 13 Apr 04:01 Oracle Applications 11i Encrypted Password String Disclosure (PDF): An undisclosed security vulnerability exists in Oracle Applications 11i that may allow an unauthenticated, internal attacker to obtain Oracle Applications’ user account encrypted password strings, which in turn can be decrypted using previously published information. An attacker can potentially obtain either any user’s password or the Oracle [... 11 Apr 03:57 Lewis Cunningham’s “mini” tip about the NO_DATA_FOUND exception in PL/SQL is interesting. He shows how this exception is not always raised when you expect it to be raised. Here is another NO_DATA_FOUND gotcha you should be aware of: Share This ---Related Articles at Eddie Awad's Blog:Two Oracle PL/SQL Features You Probably Don’t Know AboutOracle PL/SQL Best Practices [... 10 Apr 17:17 Links to interesting, educational, informational, or just plain fun websites... | | |