(Stephen Lasham) A table contains a column (particulars) consisting of a semi-colon-delimited string of text, for which the text between the first and second semi-colon needs to be extracted. The extracted text will be no longer than 99 characters. The position of the first and second semi-colo
Other News
DB2 Basics: Cloning DB2 Databases Using Redirected Restore
(Roman B. Melnyk) This article gives you the basics of cloning a DB2 for Linux, UNIX, or Windows database.
Oracle Tip: Build generics with ANYDATA and global temporary tables
(Scott Stephens) Oracle developers often avoid objects because they don’t seem to fit cleanly into PL/SQL or SQL domains. There are many operations on objects that you can’t do through pure PL/SQL (e.g., dealing with reference pointers), and there are operations that you can’t do in pure SQL (e.g.,
Designing Extensible, Versionable XML Formats
(Dare Obasanjo) An XML vocabulary should be designed in such a way that the applications that process it do not break when it is inevitably changed. One of the primary benefits of using XML for building data interchange formats is that the APIs and technologies for processing XML are quite resilient
Truncate all rows in Database
(Vinod Kumar) This is yet another fequently asked question in the public newsgroups. Here is a simple script that will allow you to do the same easily. In this script I’ve used the truncate clause rather than the delete operation because trucate is faster and doesnot get into the logging process tha
MSDN Webcast: SQL Server 2000 Performance Tuning – Finding the Right Balance of Indexes – Level 200
In SQL Server, Performance Tuning can be achieved through many avenues: hardware, software, the database and the client. While there are many pathes that yield gains, finding the imporvements that give the greatest gain with the least impact on your current systems is a must. In SQL Server there
Oracle plans to patch peck of flaws
(Robert Lemos and Matt Hines) Database software maker Oracle promised to quickly make patches available for more than 30 flaws found recently by a British security researcher. While details of the flaws have not been made public, researcher David Litchfield offered some general information about
IBM spices up content management play
(Martin LaMonica) IBM plans to spice up its content management software with XML technology that makes the storage and retrieval of corporate documents quicker and more flexible. The technology, dubbed Project Cinnamon, is being developed at the company’s Silicon Valley research labs, Big Blue s
Track Updates, Changes, and Deletions
(Sanjay Ray) This tip was written for use with Oracle8i. This code tip demonstrates a technique to track changes occurring in the underlying database tables following a sequence of events in the front-end application. That is, the user keys in data through the application, or runs a process,and the
Paging Mechanism Using XML+XSLT
(Stanimir Stanev) XSLT works pretty good to transform XML documents, but the things are getting much better when we are able to pass arguments to the XSL. This article will show how arguments can be passed without server side logic involved.