(James F. Koopmann) Identification of the database you are currently working on can sometimes be somewhat confusing. Take a look at the internal parameters that Oracle keeps and see if you can uniquely identify the database you are currently working on.
Author: SSWUG Research
Oracle Content Services 10g Web Services: Technical Paper
The Oracle Content Services 10g Web Services provide a means for third-party applications to leverage advanced document and record management capabilities in their own application. The Web Services can be used to simply integrate applications, or to build complete custom applications using the Oracl
OLAP SQL Part 3 – RANK, DENSERANK, ROWNUM
(Chris Eaton) In addition to the OLAP grouping functions there are other OLAP functions that can be used to help order rows or to show ordering within a grouping. The first of these is the RANK function. Rank will display the value of the rows order within a set. So for example if I have 10 rows in
Query DB2 XML Data with SQL
(C. M. Saracco) The DB2 Viper release, now in beta, features significant new support for storing, managing, and querying XML data. In this article, learn how to query data stored in XML columns using SQL and SQL/XML. A subsequent article will illustrate how to query XML data using XQuery, a new lang
DB2 UDB security, Part 6: Configure Kerberos for authentication on DB2 UDB for Linux, UNIX, and Windows
(Kevin Yeung-Kuen See, Yung Chung and Henry Chan) Using Kerberos for authentication provides a central repository for user IDs (or principals), thus centralizing and simplifying principal or identity management. Learn how to set up a single Kerberos realm environment for DB2 Universal Database for L
Get a leg up on XML security development with security toolkits
(Ed Tittel) Those seeking to include various aspects of XML Security infrastructure in their environments may quickly find themselves puzzled by where to go and how to gain access to such technology for runtime use. But the availability of two different developer toolkits for Java means that at leas
random_agg()
(Josh Berkus and Joe Conway) Earlier today a user came onto the #postgresql channel on IRC.freenode.net with an interesting challenge: he wanted a “random” aggregate. Jan Wieck stated that it couldn’t be done, but I thought there might be a way. Oddly, the user wasn’t satisfied with my solution (I
Top 10 Annotations and Remarks about the Wonderful and Powerful New Features in ASP.NET 2.0
(Dino Esposito) Should you use DataGrid or GridView in ASP.NET 2.0? Is SqlDataSource perhaps more appropriate than ObjectDataSource for building a data access layer? Are cookies evil or is a cookieless solution worse? These are only some common questions that developers will ponder as ASP.NET 2.0 ta
Microsoft .NET Architecture
(Joydip Kanjilal) Microsoft .NET is a framework for distributed, portable, scalable computing. This article discusses the features of the framework and the related terminologies, provides an insight to its architecture, and then discusses ASP.NET, ADO.NET, Web Services, Remoting, and the robust secu
Associative Arrays in Oracle PL/SQL: The Professional Approach
(Jagadish Chatarji) This is the second article in a series focusing on associative arrays. In this article, we shall examine recommended methodologies for working with associative arrays efficiently.