By Danny Mohar – This script is used to determine which indexes require a re-build to assist with system performance. A ratio of 10-20% deleted lf rows to lf rows may be candidates. The script will attempt the used of dynamic SQL to execute the DDL commands required to execute the analyze table comm
Community
Database Development in SQLJ, Part I: An Overview of SQLJ
by Boris Milrud – Instead of porting code in time-consuming fashion from one database platform to another, and dealing with proprietary procedural languages, use SQLJ to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms.
OASIS matchmakes portals with Web services
XML standards body OASIS has formed a technical committee to build a standard for Web services to be used with portals, dubbed the Web Services for Remote Portals (WSRP) technical committee.The group is working on a standard that will enable the plug-and-play of visual Web services into port
XML Creates Customized Information
Use XML as a standard to structure data depending on who will use the information and what format they desire the information to be in. For example, Caterpillar customizes owner's manuals for its construction and mining equipment using XML to reflect specific customer options. The manual is tail
Hidden Whitespace, Hidden Meaning
by John E. Simpson – Every time I update an XML file via an in-house content management system, the processed XML file contains masses of empty lines between the tags. Each time I edit and save the file the gaps get bigger.Here is the code that I think might contain the problem (XSL):
Oracle to ship new database release by May
By James Niccolai – Oracle plans to ship the next major release of its Oracle9i database by the end of May, in line with its original plans, an Oracle executive said Wednesday.<br><Br>Release 2 of Oracle9i will be announced officially in the coming weeks and will ship during Oracle’s fourth fiscal q
Storing Your Data in Oracle
by Joe Lax – Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Learn how locally managed tablespaces can let the database engine make most of the decisions for you.
Hidden Whitespace, Hidden Meaning
by John E. Simpson – Every time I update an XML file via an in-house content management system, the processed XML file contains masses of empty lines between the tags. Each time I edit and save the file the gaps get bigger. Here is the code that I think might contain the problem (XSL):
An updated survey of semantic transparency in XML
Once again, this column takes a break to look at what's new and what has been neglected in the normal run of discussion. This time, Uche Ogbuji examines a couple of older XML schema systems for common business transactions that are overdue for a look (xCBL, cXML), as well as a new entry to the f
Web Services Interoperability
by James Snell – In this article, I give a brief picture that highlights exactly what interoperability in Web services means. To do so, I am going to pull an example out of O'Reilly's recently published Programming Web Services with SOAP, which I coauthored. The example is the ubiquitous Hel