Put SQLJ to use. This language allows you to write stored procedures with database-independent code that can be easily ported among Java-enabled database platforms. Oracle Pro Boris Milrud demonstrates how to write, load, and run a SQLJ stored procedure on an Oracle database, and shows how its resul
Other News
Regular Cleanup of Audit Tables
(Bhagwan Singh) Description: I developed this small package to execute the cleanup of my audit tables fortnightly, after reports were done.
Microsoft eases VS.NET database development
BY: Eric B. Parizo – Thanks to a pair of new offerings from Microsoft, not only can applications built with Visual Studio.NET now connect natively to Oracle databases, but Java applications can also access Microsoft SQL Server databases. SearchVB spoke with AMR Research senior analyst Peter Urban ab
ASP.NET and SQL Server Performance Tips
Take advantage of the SQL Server .NET data provider to access SQL Server data using ADO.NET, as it offers the best overall performance. It can be used to access both SQL Server 7.0 and SQL Server 2000 databases.Check out more tips!
Upgrading from SQL Server 7 to 2000 (Part 2)
By AjarnMark from SQLTeam – In Part 1, I introduced the basic options for upsizing a SQL Server from version 7.0 to 2000. One important part of that article was the list of what has to be moved. Here in part 2, I will take that list and explain how I accomplished all of this on 53 separate databases
OASIS Signs Off on New Web Specs
By Clint Boulton – The e-business standards consortium Wednesday put the finishing touches on three committee specifications: ebXML Registry Service (RS) v2, ebXML Registry Information Model (RIM) v2 and Directory Services Markup Language (DSML) v2.
Counting with node sets
By Uche Ogbuji – Many common XSLT tasks, including simple loops, can be made easier by using special properties of node set operations. This tip discusses using node sets for simple and efficient loop control.
Transforming Experiences
by John E. Simpson – Q: Can I convert XSL Formatting Objects (XSL-FO) to HTML?<br><BR>I have an XSL-FO file that renders a PDF using FOP. Can I use the same XSL-FO file to render to XHTML? If yes, what is the tool to use?<Br><Br>A: Let's tackle the second question first: one good place to start
Oracle9i New Features for Oracle8i DBAs
By Roger Schrag – This paper offers a brief overview of the new features in the Oracle9i database of most interest to database administrators. It is written for DBAs experienced with Oracle8i who are looking for a quick-read roadmap to what has changed and what is new in Oracle9i. For each item we’l
Data Mining on a Shoestring
By Frances Keeping – Did you know that your database can tell you how to increase your revenue and build customer loyalty? With Analysis Services, mining your data for gold is easy.