Modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.
Author: SSWUG Research
JOINS in Action
The purpose of this handout is to give you mini-example of the different types of joins we covered in class using two tables. We will illustrate cross join, inner join, left outer join, right outer join, and the full outer join. For this example, I used MS Access (the screen shots look much nicer t
Using Session Handling Objects to Maintain the State of Applications with PHP Sessions
(Alejandro Gervasio) Here you have it. The tutorial that you were waiting for! Welcome to the concluding part of the series “Maintaining the state of applications with PHP sessions.” In several tutorials, this series goes through the key points of managing sessions in PHP, and explores some of their
An Insight into ADO.NET
(Joydip Kanjilal) ADO.NET is an improvement over traditional ADO as a data access technology that is used in the managed environment of Microsoft .NET. This article discusses this technology, its classes and the providers that it supports.
Utilize .NET 2.0’s powerful List class in your next project
(Tony Patton) I used to spend a lot of time working with the Lotus Domino platform and its LotusScript language. One of my favorite features about the language was the List object; it simplified working with a collection of identical objects. I was pleasantly surprised to find a similar (and more po
Using the SQLXML data type
(Deepak Vohra) J2EE developers are commonly required to store an XML document in a relational database and retrieve an XML document from a database to obtain element and attribute values. Currently, only vendor-specific technologies and data types are available to store an XML document in a relation
Oracle Multi-Directional Data Replication
(Vincent Chan) In part one of this series, we illustrated the procedures for setting up bi-directional data replication and conflict resolution between two databases using Oracle 10g Streams. In the second half of this series, we will provide the steps to add a new source site into our existing bi-d
Why Oracle Works the Way it Does (6) – The SGA
(Dratz) The System Global Area (SGA) is powerful set of memory components that help you make Oracle very performant and scalable.
LINQ Into Microsoft’s New Query Capabilities
(Markus Egger) At PDC 2005, Microsoft introduced brand new technology known as LINQ, which stands for “Language Integrated Query.”
Oracle announces general availability of Oracle Secure Backup
(Dave Chappelle) Oracle has announced the general availability of Oracle Secure Backup, intended to deliver high-performance network tape backup for Oracle databases and file systems on Linux, UNIX, and Windows platforms.