Archive for

A Short Guide to Oracle SQL [I] – RDBMS Basic Concepts

The following post(s) is just a review of RDBMS/SQL fundamentals what learned when I start using ORACLE and during SQL certification exam. I’ll try to put things in an ordered manner. The posts will have links to other blogs and oracle doc which helps me to understand SQL. Your comments and feedback are welcome. Database … Continue reading

Flashback Database

Before Oracle 10g, if the database suffered some logical data corruptions or user errors, your choice would be Point-in-time recovery. That means restoring datafiles from backup and after that using archived redo logs to applying changes. In short, it was a costly and time-consuming process. Flashback Database is another flashback technique that can be used … Continue reading