(Raafat Abdulfattah) This example shows how to insert up to 32000 characters in an Oracle CLOB field using ASP code. I’ll be writing another article to demonstrate the insertion of more than that later on. The example should work with Oracle 8,9 and 10g.

(Jisheng) Big Pages in RHEL2.1 and Huge Pages in RHEL 3/4 are very useful for large Oracle SGA sizes and in general for systems with large amount of physical memory. It optimizes the use of Translation Lookaside Buffers (TLB), locks these larger pages in RAM, and the system has less bookkeeping work

(Rudy Limeback) I want to use COUNT on two columns within the same statement. My query goes like this: select column1, column2 from table1, table2 where field1.table1 = field2.table2 (R)

(Lewis R Cunningham) I’m going to be expanding my entries on learning Oracle to include PL/SQL. I’ve already written a few entries about basic SQL. Today I start writing about basic PL/SQL. I’m going to keep these entries bite-sized and never more than 2 or 3 topics per entry. Today is a discussion

(Mark A. Williams) For features and performance, Oracle Data Provider for .NET (ODP.NET) is your best choice for connecting .NET applications with Oracle Database.

(Avram Roy-Faderman, Peter Koletzke, and Paul Dorsey) Java client applications are standalone programs that run in a Java Virtual Machine (JVM) on the Client Tier. The user interface portion is usually written using Sun’s Swing components and other third-party components (for example, for graphs a

(Angela Eager) Oracle has in recent times not so much been throwing off the old to bring in the new, as hanging onto the old while adding the new. It has considerably changed the shape of its business and is now presenting a new face to the world.

(Mark Brunelli) Oracle’s recent maneuvers in the open source software market are all about the upsell, according to one IT industry analyst. (R)

(Srinath Shankar, Ameet Kini, David J DeWitt and Jeffrey Naughton) There has been an information explosion in fields of science such as high energy physics, astronomy, environmental sciences and biology. There is a critical need for automated systems to manage scientific applications and data. Dat

(Bob Watkins) Data warehouses are often populated by multiple source systems, each running their own applications.