(Roger Schrag) This paper will walk you through the steps of installing Oracle Database 10g release 2 (Oracle version 10.2.0) in a Linux environment. About 90% of the material presented here applies to other platforms as well. Everything you read in this paper is hands on, roll-up-your-sleeves-and-g

(Barney Beal) Despite repeated assurances by Oracle Corp. executives that Siebel will remain the centerpiece of the company’s CRM applications as it moves forward with Fusion, questions — and concerns — linger in the Siebel customer base. (R)

(Steve Callan) When creating large tables (large referring to the amount of data), you may want to consider creating them with the nologging option. If the data is of a transient nature, that is, the table is used for staging and other manipulation will transform it into yet another table, do you re

(Raj Mattamal) When talking about Oracle Application Express, I find that the concept of authentication is easy to explain. Access control within applications, however, seems to be a bit more difficult to convey. With that in mind, I’d like to walk through the process of creating an application and

(Babette Turner-Underwood) When you create a table in logging mode and the table has LOBs, the LOB columns will take the logging mode of the TABLESPACE. That is right, not the table but the TABLESPACE. So if you have a tablespace that is NOLOGGING and you create the LOB segments of a table in the NO

(Brian Peasland) What is an instance? Can we open more than one instance in a machine? (R)

Register for this complimentary Webcast to learn how IBM can assist in getting your applications current, while keeping your business ahead of the curve. (R, webcast)

(Lewis R Cunningham) I started working on a task for a project and decided that there were some very good properties that I could use to help me teach people PL/SQL and XML. I expanded a bit on the idea and ended up with a scripting language, implemented in XML, that can be passed into a PL/SQL proc

Don’t miss Oracle Develop, the premier developer program, coming to Oracle OpenWorld this Fall! At Oracle Develop, you’ll hear from world-leading experts as they share their knowledge on how to simplify development using popular technologies like Java, .NET, XML, and PL/SQL, as well as Ajax, PHP, Sp

(Bob Watkins) Associative arrays, formerly called INDEX BY tables, have been a feature of the PL/SQL language since version 2. They are sparse arrays, meaning that only the elements you load into them are stored. No space is reserved for in-between index values. One of their original limitations, ho