(Jose Luis Messina) This code counts repeated strings.

(Lucas Jellema) In this article I would like to demonstrate another unexpected usage of ADF BC bind-parameters. In a previous entry I argued that bind parameters are typically seen as good only for the where-clause of an SQL query underlying a ViewObject. In that entry I showed using a bind paramete

(René Nyffenegger) The as of clause in a select statement allows to see the data as of a past SCN or past point in time. So, it’s possible, for example, to compare the current data in a table with a previous data set. This is what I try to do.

This is a collection of 23 FAQs on working with database objects in PL/SQL. Clear answers are provided with tutorial exercises on running DML statements, assign table data to variables, using the implicit cursor, defining and using RECORDs with table rows.

(Lewis Cunningham) The entry builds directly on my last entry, Oracle Streams Configuration: Change Data Capture. This entry will show you how to propagate the changes you captured in that entry to a 9i database.

(Frank Zhou) This query generates permutations for X number of unique characters or numbers.

The process involves making a full backup of your production database on the primary server. This can be either a hot or a cold backup. If a hot backup is used, then the archive log files created during the backup will also need to be copied to the standby database. (pdf)

(Lucas Jellema) Some things are almost to tiny to blog about. Then again, if a blog can save you a lot of work and frustration then, even it is about something very small, perhaps it is worth it after all. Today’s topic: ADF BC Entity Objects in combination with Views that have an Instead Of trigger

(Tarry Singh) In this article, we will continue our discussion of Oracle RAC DBA essentials. We have already looked at Enterprise Linux and will continue to build our “Oracle RAC Appliance” on the Oracle Enterprise Linux layer.

(Jim Czuprynski) In the previous articles in this series, we first discussed how to implement fine-grained auditing using Oracle 10g’s enhanced DBMS_FGA package. We then looked at methods that prevent users from querying or changing data via the fine-grained access control tools that are supplied wi