(Alf Pedersen) Constraint naming standard are important for many reasons, but one of the most important reason is that the SYS_* name oracle assigns to unnamed constraints is not very understandable. By correctly naming all constraints, we can quickly associate a particular constraint with our data

(John G. Spooner) Oracle has purchased database maker Sleepycat for an undisclosed sum. Database giant Oracle announced the acquisition on Feb. 14, saying it would add Sleepycat’s Berkeley DB to its line of embedded databases.

(Natalka Roshak) In our increasingly interconnected world, it’s more and more important for code to be able to handle time zones gracefully. For example, if call centers in Bangalore and London use the same call center application, then the code that writes call logs to the database will have to be

(Brian Peasland) I took the RMAN hot backup on database open stage. What steps should I follow to recover the database using the RMAN hot backup? Can I do it in database mount stage or open stage? (R)

(Paul Krill) Oracle has just released a free JDeveloper Java development tool, in an attempt to compete with the open source community Eclipse.

(James F. Koopmann) Everyone needs a little help now and then. If you have never used Oracle’s help facility, venture with me and find new ways you can provide benefit to your users of SQL*Plus through this simple interface.

(Munir Kotadia) Oracle has shrugged off criticisms of its recent security record, saying that one of the company’s biggest security concerns is that its customers are so used to being secure that they are not used to applying patches.

(Kamlesh Jethwa) Often, data in Oracle applications is stored in extended columns known as Descriptive Flex Field (DFF) columns. These are character columns which you can map to store any kind of information. On the front end, it is possible to apply validations like numeric, date, or character but

(Kevin Loney and Bob Bryla) Managing application development can be a difficult process. From a DBA’s perspective, the best way to manage the development process is to become an integral part of teams involved in the process. In this chapter, you will learn the guidelines for migrating applications

(Mark Rittman) When you work with the OLAP functionality in Oracle Database 10g, you need to be aware of how it handles memory. Just like a relational data warehouse, data held in multidimensional datatypes makes use of memory structures such as the System Global Area (SGA), Program Global Area (PGA