(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.
Other News
Differences Between DB2 CLI and Embedded SQL
An application that uses an embedded SQL interface requires a precompiler to convert the SQL statements into code. Code is compiled, bound to the database, and executed. In contrast, a DB2 CLI application does not require precompilation or binding, but instead uses a standard set of functions to exe
Oracle Moves to Upgrade Support for Database Users
(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.
Distribution Specific Considerations
In this part of the HOWTO, we will cover any tweaks, fixes or requirements that need to be made to get DB2 UDB running on specific Linux distributions.
Object-Relational Database Systems
(Michael Gertz) The goal in this chapter is to understand the basic concepts of object-relational database systems, the object-relational data model and its realization in database systems, such as Oracle 10g, learn basic architectural options and concepts behind ORDBMS. (pdf)
Using Snippets in Visual Studio 2005
(Michael Gold) I finally found some time to download Visual Studio 2005 and take a look at some of its powerful new features. One feature that struck me as a real time saver was the new code snippet Intellisense feature. This feature allows you to create pieces of commonly used code with just a
Checklist: Load testing — the magic bullet for SQL Server performance tuning
Few things are worse than rolling out a new application and its performance is so bad that it brings the business to a screeching halt. This is not a new phenomenon; it’s a reality that I have seen from time to time. I am willing to bet that you have experienced it, too. So what is the solution for
Oracle and SAP Unleash Strategic Initiatives
(Lee Kroon) In recent weeks, Oracle Corporation and SAP have made strategic announcements about how they will enhance their core business applications over the next several years. The announcements increase the rivalry between the two enterprise application vendors and present their customers with n
XOsoft’s Assured Recovery Speeds Disaster Recovery
(Brian Fonseca) XOsoft Inc. will make available its Assured Recovery software, a new product that allows customers to perform fully automated scheduled tests of applications without disrupting an IT environment.
PHP and JavaScript Interaction: Storing Data in the Client – Part 2
(Alejandro Gervasio) In the first article in this series, we developed a simple PHP function that dynamically generates a JavaScript array and populates it with external incoming data. In this article, we will develop a real world application using this method, in the form of a news ticker.