Home » Articles / Blogs

Developer

Creating Custom Aggregate Functions in C/ C++

Submitted by Marcin Moczyróg on Sun, 2005-12-25 18:01.

The aim of this article is to describe the process of creating a user-defined aggregate function. Oracle 9i was used to prepare and test the function; some parts of the code may not work with Oracle versions older than 9i. This article gathers information that is needed to write the aggregate function in one place, and presents a clear step-by-step descripion of the process.

»

Get Started on XML

Submitted by Saikat Goswami on Sun, 2004-09-12 00:00.
Saikat Goswami's picture

XML is everywhere. Whether you are an Oracle system administrator, a .NET developer, or a J2EE analyst, XML undoubtedly is something that you bump into. In this article, I attempted to give you the basics of what you need to know to jumpstart your understanding of XML.

»

Candidate keys: Choosing the right primary key

Submitted by admin on Mon, 2004-03-22 00:00.

It is the business that has the knowledge about their entities (things of importance) and what kind of unique information that separate them (invoice numbers, customer IDs, and so on).

Your role as an analyst/designer is to validate such properties, and to fit them into a normalized database model that reflects the needs of the business.

»