Multi field Indexes in SQL
I'm wanting to update or delete records in one table using a multi field index
obtained from the results from a subquery.
An example of what I have done in the past is:
Where Key1||Key2||Key3 in (
Where FieldD = 0);
Is there a better way on Oracle 7.3.4?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL