Back to the basics: Everything you always wanted to know about the syntax and options you can use when creating a table in Oracle.
Other News
Gates Envisions New Era of Seamless Computing at COMDEX
In his 20th annual COMDEX Las Vegas keynote address, Microsoft Corp. chairman and chief software architect Bill Gates outlined the company’s vision for Seamless Computing, a framework for software innovation that addresses the fundamental issues computer users face today, unlocks the value of comput
Applying patches? Call a doctor!
(Diana Kelley) Patch management is a little like flossing your teeth. Everyone knows they’re supposed to do it, but most of us still don’t. Some pundits say the simple answer for patching lies in proactivity. Get the patch applied before an incident occurs, and keep the problem from occurring ra
Tip #61: A Cross between NVL and DECODE: The NVL2 Function. (Type: SQL*Plus)
(Ken Atkins) This quick tip is about a little-known (at least I had not known about it!) function in SQL called NVL2 that acts kind of like a combination of NVL and DECODE. It has been available since 8i.
More Gems From the Mines
(Uche Ogbuji)This article pulls together information on Python, generating output with XML and a host of other tips, including a DOM Node Builder.
Create a clustered index on primary key
(Prashant Dahalkar) Here’s a way to create a table with clustered index on a composite primary key. A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore, the table can have only one clustered index. The leaf nodes of a clustered ind
Expiration Date Calculator
(John Peterson) Some scripts you have to write… others you write because they’re interesting or just plain cool… and finally there are scripts like this… scripts that don’t do much and take longer to write then it would have taken you to just do what you wrote the script to do! Let me expl
Virtualize This!
(David Stodder) On September 22, at the IBM Almaden Research Center in San Jose, California, friends, relatives, and former colleagues of Dr. Edgar F. Codd gathered for "an afternoon of tribute and celebration" of his life and work. The greatest legacy left behind by Codd, who passed away on April 1
Benefits of XML in Business
(Phoebe Yi, Paul Fretter and Sophie Zhong) XML has become a hot topic over recent years due to its core qualities: extensibility, platform independence, and self-describing nature to name a few. Considered by many to solve a wide variety of e-problems, it has enjoyed an optimistic following that bel
Sort Dates With XSLT
(Dan Wahlin) XSLT 1.0 doesn’t let you sort dates using the xsl:sort tag. This can present a problem because dates frequently play an important role in various applications. For example, XSLT doesn’t let you sort the Customer nodes based upon the data contained within the CustomerSince nodes in this