Watch the FlashBack Database video (20 min) on how to return the database to a point in the past using either the SCN (system change number) or a specified time. Go to the FlashBack Database webpage on Morgan’s library to try the code yourself.
These are excellent videos (with nice classical introductory music) and I hope that Dan will post more videos on more Oracle topics in the future.
Note: You need the free RealMedia Player to watch the videos.Comments Off | Filed in Oracle | Tags: 10g, 11g, flashback
What is the first thing you do when a new version of an Oracle database (or any software) is released? You immediately look for the “what’s new” document, right?
I believe that the “What’s new” document is very important because it informs you of new (or modified) features that is supposed to make your life easier and your applications more powerful.
Take advantage of “what’s new”. After all, you’re paying for these new features (I assume), so use them or lose them.
To that end, here is a list of “what’s new” links. They will take you straight to the corresponding section of the Oracle documentation:
What’s new in Oracle Database version:
What’s new in SQL in Oracle Database version:
What’s new in PL/SQL in Oracle Database version:3 Comments | Filed in Oracle, Tips | Tags: 10g, 11g, 12c, 9i, Documentation
While reading the book Expert Oracle Database Architecture, I noticed a very important bit of information about the DUAL table. In 10g, Oracle does not do a full table scan on DUAL if it does not need to. This is not the case in versions prior to 10g. To illustrate: Continue reading…5 Comments | Filed in Oracle, Tips | Tags: 10g, dual
On the Oracle-l mailing list, Jared Still posted a message about a little experiment he did which concluded that Oracle (10gR1) always makes sure that DUAL returns one and only one row even if it contains more than one row.
I have repeated the experiment on my Oracle 10g XE database (Important: Do not do this dangerous stuff on your production database. Never insert/delete/update DUAL): Continue reading…9 Comments | Filed in Oracle | Tags: 10g, dual
I stumbled upon a a technical white paper that provides a feature comparison between MSSQL 2005 (Yukon) and Oracle 10g databases. Here are a few points I noted from the paper, quoting:
I bet that you did not believe your eyes when you saw the two words “Free” and “Oracle” right next to each other, did you? Well, it happened a few hours ago. Oracle has now a “freebie” database of the 10g version, the Oracle Database 10g Express Edition. So what is Oracle Database 10g Express Edition? According to this tutorial (via Sergio): Continue reading…4 Comments | Filed in Oracle | Tags: 10g, xe
If you want to improve your ability to search and manipulate character data, regular expressions, a notation for describing textual patterns, is for you. And if you have Oracle Database 10g, you’re in luck, as the regular expressions feature was introduced starting with that release. Here are a couple of links that will help you understand and use regular expressions in your Oracle code (courtesy of Robert Vollman):1 Comment | Filed in Oracle | Tags: 10g, regular-expression