by Sanjay Mishra, Alan Beaulieu – If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle’s implementation of SQL, is the key to writing good queries in a ti
Other News
Oracle 9i R1 allows any user to access any table
By Chris Eaton – This was posted on the forum (comp.database.oracle.server) and I have tried it on my test system and it is a real problem: Any user can access any table using 9i. Someone on the forum posted that there is a TAR 2121935 open stating that it will be fixed in 9iR2 and not in 9.0.x. I s
Privacy and XML, Part 2
by Paul Madsen, Carlisle Adams – There are a number of efforts currently underway in standards bodies and other organizations to address various aspects of privacy with XML-based technologies. This section gives an overview of this work, noting which of the privacy concepts discussed in the first pa
Interactive Java & JDOM Online Tutorial
James Britt walks through the Java JDOM in this 45 page online interactive tutorial. This tutorial includes complete coverage of the JDOM objects from creation, through to SAX and Java-based exception handling.
Libxslt 1.0.17
Code cleanup, XSLT debugger support, EXSLT date improvements, Windows Makefile improvements.
SQL Server CE 2.0 Might Foster the Killer App
By Brian Moran – Microsoft’s new .NET Compact Framework and SQL Server CE 2.0 might encourage the development of killer apps for mobile devices that even SQL Server administrators couldn’t live without.
Moving from Access to SQL Server
By Jorge Cano – These kinds of tasks are a little more complex because we have to take care of the objects that we’ll move (or migrate) from Access to SQL Server. SQL Server has some tools and wizards that can help you, like the Enterprise Manager, Query Analyzer and others. SQL Server does not mana
Take Advantage of SQLXML with ASP.NET
Randy Holloway explains how to use SQLXML 3.0 with SQL Server to expose Web services through your ASP.NET applications by executing T-SQL stored procedures and user-defined functions.
Losing the E
By David Baum – Leveraging the internet to improve business communications and processes is still referred to as “e-business,” but these Oracle customers say e-business will soon become the standard for all business.
Auditing LOGOFF and LOGON
(Milind Deobhankar) Auditing the database to find out who is logged on, who has logged off, from which machines users are logged in, and from which program users are connected can be a very cumbersome task. Here is a procedure that will help the DBA to trace who has logged on, logged off, and at wh