(David Gornshtein and Boris Tamarkin) In this short topic we will explain relatively simple case of distributed lock problem. Shortly we will present two additional topics regarding usage of “oradebug lkdebug” statement and another topic about reading results of “oradebug -g all hanganalyze 3″ and ”

(James Koopmann) In the previous Part of this series we looked at the ‘simple SELECT’ statement. This involved the four required pieces of a SQL statement. Namely the key word SELECT, a select list or columns we wanted to return from the table, the FROM key word to specify the table information was

(Jack Loftus) Rich Pickett, the director of administrative information services at the University of San Diego (USD), had a paper problem. (R)

(Scott Stephens) The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It’s a bit trickier to go in the other direction. I’ve seen a lot of requests for help from developers looking for a way to pass an

(Sanket Bakshi) The data-retrieval layer of Microsoft SQL Server Reporting Services (SSRS) supports a variety of data sources, including MS SQL Server, Oracle, ODCB, OLE DB, as well as several custom ones. The product has been optimized for MS SQL Server, so SSRS interacts seamlessly with that data

(Jagadish Chatarji) This is part 11 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I introduced the concept of the explicit cursor and looked at several approaches for using the explicit cursors. In this article, we shall delve more deeply into

(Lewis R Cunningham) The basic Data Manipulation Language (DML) commands that have been in use over the years are Update, Insert and Delete. They do exactly what you expect: Insert adds new records, Update modifies existing records and Delete removes records.

(Chris Schalk) RSS, which stands for Really Simple Syndicate, is basically an XML format for content on the Web that purely represents the content of an Web page without any extraneous presentation or “look and feel” and can thus be syndicated and represented in multiple sites. This contrasts with a

(Barbara Darrow) Oracle is breaking out its checkbook again, this time to acquire technology and staff from Context Media, a Providence, R.I.-based content integration company, industry sources said.

(Ilia Alshanetsky) In this article, I will describe some of the easiest and most effective techniques for accelerating your PHP applications, which include but are not limited to the use of a script cache, proper Web server and PHP configuration and tuning, and benchmarking and profiling. With t