Steven Feuerstein and Bryn Llewellyn show how, with Oracle 9i Release 2, you can now use the PL/SQL RECORD datatype inside SQL statements.
Other News
Determine used and free space in a tablespace
by sunitha s – This small Oracle script can be executed as a script file from the SQL*Plus prompt and reports the total size, used space, free space and percentage of used and free space in all the tablespaces in a database. (R)
Will the Real Database Leader Please Stand Up?
In some corners of the IT world, there is very little real competition and no question who leads the market. For example, Microsoft has the lock on desktop operating systems and Apache rules Web servers, and no one expects that to change in the near future. There is a little more suspense when it co
How to Identify and Delete Duplicate SQL Server Records
by Randy Dyess – Deleting duplicate SQL Server records is not as easy as you might expect. Learn how to identify and delete duplicate records in this article.
XyEnterprise Announces Release of XML Professional Publisher 7.2
XyEnterprise, the leading developer of XML content management and enterprise publishing software, announced that it has released XML Professional Publisher Version 7.2. This latest release of XyEnterprise’s powerful publishing software contains new features designed to enhance the creation, deployme
Edit XML Content Visually
by Dan Wahlin – Simplify enterprise content management with Authentic 5, a free XML editing tool that lets you visually update content and business data through the Web or from the desktop.
At Microsoft’s Mercy
by Kendall Grant Clark – In a recent XML-Deviant column, “The Pace of Innovation”, I examined the still contentious, often puzzling issue of XML tools support, especially for end users. Even after five long years of XML development, the ideal and ubiquitous “XML editor for humans” seems more rumor t
Inline or Embedded SQL vs. Stored Procedures
Recompilations might be the source of the slower stored procedure speed. To find out for sure, you need to do some performance investigation, such as looking at Showplans for each type of query versus calling the stored procedures and comparing query plan cache hits to cache misses.
A Comparison of SQL Server 2000 With Sybase ASE 12.5
Price, performance, product limitations – how SQL Server 2000 stacks up against Sybase ASE 12.5.
The Database Holds Your Core Assets—Protect It First
by Glen Kunene – If data is the core asset of all applications, why is database security so often relegated to a secondary consideration? Two database security experts explain why locking down your database should be a top priority and offer solutions for making it happen.