(Jagadish Chatarji) This article is part of a series focusing on database interactions with Oracle PL/SQL. In my previous article, we examined named notation, default values of parameters, stored procedures, stored functions and finally took our first look at package and package body. In this articl
Tag: Oracle
Siebel Will Be ‘Centerpiece’ Of Oracle CRM Strategy After $5.85 Billion Deal
(Paul McDougall and John Foley) Oracle disclosed plans to acquire CRM-market leader Siebel Systems Inc. for $5.85 billion, a deal that brings together two of the software industry’s largest business-application providers.
Optimize Result Set Retrieval Using ODP.NET and Ref Cursors
(Mark A. Williams) There are several ways to return query results from an Oracle database to a client application, using Oracle Data Provider for .NET; one of the most powerful, flexible, and scalable methods is to use ref cursor. This article introduces ref cursors and why they are useful, incl
Web Services—Anyhow, Anywhere
(Marta Bright) Flexible. Faster. Better. Easier. These are words that every developer not only loves to hear, but also steadfastly wants to believe in. But when you’re developing Web services, integrating legacy applications with newer services across different protocols, are there any magic standar
Autodesk, Oracle to Provide Integrated Geospatial Solutions
Autodesk, Inc. announced it will provide integrated geospatial solutions with Oracle to enable customers to maximize operational efficiencies, based on a wealth of location and structural data. Autodesk will work with Oracle to market solutions in strategic markets such as government, utilities, tel
DeployPHP Series, Part 4: Using the PEAR::MDB2 Database Abstraction Layer with Oracle
(Tobias Schlitt) PEAR (PHP Extension and Application Repository) is a huge collection of high-quality PHP components. The repository contains PHP classes for almost any imaginable purpose, from database authentication, to networking, to images, to XML.
Experiences with Oracle 10g Database for Linux on zSeries
(Mike Ebbers, Kathryn Arrell, Laurent Dupin, Dennis Dutcavich, Terry Elliott, Barton Robinson and Tom Russell) Linux on zSeries offers many advantages to customers who rely upon IBM mainframe systems to run their businesses. Linux on zSeries takes advantage of the qualities of service in the zSeries
Override Default Optimizer Behaviour for SQL in PL/SQL blocks
(Garry Robinson) Oracle’s default behaviour dictates that SQL statements embedded in a PL/SQL block are always executed with the ALL_ROWS optimization method. For OLTP applications that rely on packaged stored procedures, this can be bad news for response times. OLTP queries need to return results b
New Microsoft and Oracle initiatives eye mid-market
Software giants Microsoft Corp and Oracle Corp are both sharpening their focus on opportunities on small and medium sized businesses, a market that both companies still see as being largely underserved.
Oracle names Open-Source Evangelist
(Martin LaMonica) Oracle has hired a Chief Open Source Evangelist, named Omar Tazi, who vowed that Oracle would be contributing more to the open-source community.