(Neil Chandler) A frequently reoccuring design problem with relational databases is the issue locating unprocessed rows in a large table, so we know which rows of data are still yet to be processed.

(mdinh) I typically don’t like to see WARNING if I can help it.

(Ben) Creating database tables in Oracle is one of the most common tasks an Oracle developer or Oracle DBA does. Learn how to create tables, what the syntax is, and see some examples in this article.

(mdinh) So what’s different from this post versus other posts? I share my mistakes with you.

(Neil Chandler) Just realized that I wrote a follow-up to Part 2 two years ago and never posted it! So here’s the stripped-out key facts to round off auditing control a bit more:

(Dan Jankowski) A pipelined table function may be called from regular SQL using the TABLE collection expression, e.g.

(ilmarkerm) I got a really surprising error message today when setting up a new data guard standby database.

(Andrejus Baranovskis) One of the most typical use cases in enterprise applications – Master-Detail relationship implementation. I have decided to implement it in JET and to share this practical implementation with you.

(Ben) In this article, I’ll explain how to use the Oracle BITAND function and show you some examples.

(connormcdonald) In the previous post, I showed that even though a partition was “removed” (ie, exchanged out) from a table, a query running against the table could still successfully run the completion.