The technique makes a presentable conversion of the result from substraction between dates. For example, suppose we are looking for how many days, hours, minutes, etc. we spend between two dates, say at the beginning and ending the job/project/compaign. Oracle returns the result in days (such as 2.2
Community
How to modify the snapshot structure without dropping the table
By riadh amari – This script modifies the structure of a snapshot for Oracle replication without dropping and recreating the snapshot. (It’s very useful but you have to be careful–it should be done by a DBA only.)
‘SQLsnake’ Worm Blamed For Spike In Port 1433 Scans
By Brian McWilliams – Officials at the SANS Institute, a computer security education and analysis organization, also reported today that they have received “exploit code” that indicates the increase in port 1433 scans may be due to a self-propagating worm rather than to manual probes by would-be att
Microsoft Plans SQL Server Security Guide
By Brian Moran – Microsoft is preparing a new best-practices guide that specifically addresses managing security vulnerabilities in a SQL Server environment.
Index Tuning Wizard – Part 1 (Automatic Index Selection)
By Guy van den berg – New to SQL Server 7.0 the Index Tuning Wizard is one of the many novel self-administrative features included in this release. Within this series of articles I’ll take a look at the wizard, how best to use it and how to interpret its’ output.
Take the Sting Out of SAX: Generate SAX Parsers with XML Schemas
By Leon Messerschmidt – Although SAX (the Simple API for XML) parsers are handy tools for parsing XML content, developing and maintaining a SAX parser can prove difficult. In this article, Leon Messerschmidt shows you how to use the information contained in XML Schemas to generate source code for a
Tip: Outputting HTML from an XSL style sheet
By Nicholas Chase – Because HTML is so similar to XML, it should be fairly straightforward to create an XSLT style sheet that outputs HTML. Unfortunately, the differences between HTML and XML that do exist can cause pages to be displayed incorrectly in older browsers. This tip discusses those differ
Transforming XML with XSLT and ASP.NET
Sample chapter from XML for ASP.NET Developers by Dan Wahlin – What exactly is XSLT useful for and why would you, as an ASP.NET developer, want to learn about it? The answer boils down to the capability of XSLT to transform XML documents into different formats that can be consumed by a variety of de
Java Tools Target Web Services
By Jay Lyman – Both Oracle and Borland are introducing versions of their software that will allow them to be significant players in the next big revenue-producing segment: Web services.Oracle’s new Oracle 9i Developer Suite includes a new JDeveloper Java development application for building
Oracle contract raises issues of security, privacy
By Robert Salladay – The furious political debate over California’s botched contract with Oracle Corp. has overlooked a critical question: Why let one company’s software dominate the state’s vast information databank?