(Aradhana Puri) Oracle Database 10g introduces significant advances in the area of Oracle Flashback technology. In my last column, I discussed sample questions related to Oracle Flashback Drop and Oracle Flashback Version Query. In this column, I continue my discussion of Oracle Flashback technology

(Lewis R Cunningham) In part 1 I covered the basics of creating an Oracle object type and showing how it compared to a Java class. Today I’m going to cover the concepts of comparing objects and Inheritance. In part 3, I will cover type evolution and Polymorphism and in part 4 I will cover Object Vie

(Steve Callan) In a previous article on LogMiner, the steps for setting up your environment to use this tool were shown. Oracle’s documentation lists several ways LogMiner can be used to recover lost data. Generally, “lost” in this case means a user error induced type of loss. Under the appropriate

(Paul Korzeniowski) The bickering, backstabbing, and bomb throwing is now over, and officials from Oracle Corp. and PeopleSoft Inc. have to focus on their most difficult task: making the most of their merger. After a seemingly endless stream of stops and starts, Oracle unveiled a blueprint to t

(Scott Stephens) Within a single schema, a table or view can only have triggers of each of the four main types defined: before row, after row, before statement, and after statement. See how you can avoid that kind of conflict.

(Lou Agosta) Legacy databases have declined from 12% to 3% of installed data warehousing platforms, according to the August 2004 TDWI-Forrester Quarterly Technology Survey. With Oracle databases (all versions) being the platform for production data warehousing according to 44% of respondents, Forres

(Barry Trute) Designing and setting up a new database system can take a lot of planning. But typically, one important decision is overlooked: choosing the right character set.

(Mark Brunelli) The Oracle Collaboration Suite is getting a facelift. Due out this summer, the third version of the product will be known as Oracle Collaboration Suite 10g release 1 and will feature major enhancements to its file management and group collaboration capabilities. SearchOracle.com rece

(Sean Dillon) Oracle users have grown accustomed to using the SQL interface to interact with a database. To put data in, you use the INSERT statement. To change existing data, you use an UPDATE, and to remove data, you use a DELETE. Security is accomplished with GRANT and REVOKE statements.

(Marc L. Songini) Looking to keep its installed base happy, Oracle Corp. has quietly begun a number of educational and technical initiatives in recent months to beef up its database and application server support offerings.