From SQLTeam – We’ve got a quite a few articles on randomly selecting and ordering rows. I’m still amazed how popular that topic is. I recently stumbled across a post in the forums that led me to a better way to accomplish this. This has actually been posted a few times before. I’m just finally catc
Community
Access, VB and SQL Server wildcard characters
by James Crowley – Visual Basic gives you several ways to provide pattern-matches in a search string. Typically, you use pattern-matching characters for two purposes: to search for strings in a VB application’s GUI or variable, or to look for items within a database, such as Access or SQL. When you
IBM drops Internet patent bombshell
By David Berlind – A recent IBM patent claim could threaten royalty-free access to a key Internet standard protocol backed by the United Nations. The standard–called ebXML–is an XML-based set of definitions for electronic transactions and business collaboration.
Revised DOM Level 3 drafts
The W3C has released new draft of Document Object Model (DOM) Level 3 Abstract Schemas and Load and Save Specification and Document Object Model (DOM) Level 3 Core Specification.
Perl and XML on the Command Line
by Kip Hampton – Over the last several months we have explored some the of ways that Perl's XML modules can by used to create complex, modern Web publishing systems. Also, the growing success of projects like AxKit, Bricolage, and others shows the combination of Perl and XML to be quite capable
The SPFILE
By Venu G. – The purpose of this article is to help you become familiar with one of Oracle9i’s new features, the server parameter file – aka SPFILE.
Calculate the Space Allocated, Space Used, and Space Free
by Sravan Patharla – Usually there are no dictionary views that can be used to find the space usage information about Indexes. Oracle, however, has a package, DBMS_SPACE, that you can use to find the space usage information of either an index or a table, but only for one object at a time.
Whip Your Queries Into Shape
(Andy Clark) Much of the data you work with is probably hierarchical, and hierarchical cursors are a convenient tool you can use to work with data organization. In this column, I’ll show you how to use hierarchical cursors to develop programs quickly that access data the way your users think about i
Inserting Images into Database
In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database. After this article you
How Valuable Are Benchmark Scores?
By Brian Moran – You can’t judge a book by its cover, and you can’t judge a benchmark by its raw score. On behalf of PC Magazine and eWeek, eTesting Labs recently conducted database- and application-server benchmark tests.