by Keshav Chennakeshav – In OLTP applications, data gets created and updated. An audit trail is often required to know who created a record and who updated it. A “SELECT NVL(user, SYS.login_user) FROM DUAL” query shows the database login account. The function below is helpful when the database login
Other News
Notification Services Capacity Planning and Performance Tuning
Discover the capabilities of Notification Services, common performance bottlenecks, and ways that you can design and test your own systems and Notification Services applications for optimal performance.
More cracks appear in ‘unbreakable’ Oracle wares
By David Watson – Oracle’s promise of “unbreakable” databases and application servers has yet again found to be wanting, but New Zealand’s Oracle User Group (NZOUG) president says the company has actually been very clever.
Partners; 64-Bit SQL Server Will Find Home In Midmarket
By Barbara Darrow – When Microsoft delivers 64-bit SQL Server to manufacturing next week, it’s not just enterprises that will reap the benefits. Many partners said they see interest from the midmarket as well.
Corel XMetaL 4, and XML authoring platform
Once again, Corel has improved the way organizations create and edit XML content. Introducing Corel® XMetaL® 4: a new set of tools designed to simplify the implementation of XML applications across an organization.
Introduction to MSSQL Server 2000 Analysis Services: Drilling Through to Details: From Two Perspectives
Explore the drillthrough capabilities that debut in Microsoft SQL Server 2000 Analysis Services. Join Author Bill Pearson in a hands-on tutorial that examines the exciting new drillthrough capabilities, from both user and design perspectives, and discover how to make it possible for information cons
A certification primer for XML and related technologies
XML has spread like wildfire throughout the IT industry, creating a broad range of opportunities for developers. What’s the best way to take advantage of such opportunities? In the competitive world of software development, it’s important to stand above the crowd. Thus, some standard for measuring h
Yet another Java XML API: xmlpull
XML processing is moving into the non-PC space, with PDAs and mobile phones acting as Web services clients and synchronizing their content with desktops via SyncML. Conserving heap and stack memory is a key requirement in this environment. With xmlpull, a new API has been devised for parsing XML.
The Social Meaning of RDF
The W3C is about to undertake a discussion of what the social meaning of RDF is — what the real world import is of an RDF statement. Kendall Clark previews the debate and recent related discussion.
Oracle database event triggering
By Scott Robinson – Consultants with Oracle expertise will likely find themselves working with an ERP implementation. Here’s a look at two common situations that you’ll address: working with Oracle’s database link and setting up embedded transactions.