(Sudhindra Chillarige) Everyone has a favorite script to find the active SQL statements. Here is one of mine. It builds the information using an anonymous PL/SQL block. It reads the information of active sessions from gv$session_wait and gv$session. (They have been made generic to support RAC in
Other News
Writing Language-Portable Transact-SQL
(Ken Henderson) In this month’s column, I’ll discuss a few of the issues facing developers who wish to write Transact-SQL code that is portable across languages. The introduction of Unicode data types, collations, and various other internationalization and localization features in SQL Server 7.0
Optimizing Variables and Parameters
(Kalen Delaney) Last month, in “Inside Search Arguments” (InstantDoc ID 42349), I discussed specific types of search arguments—which I call SARGs—that are most beneficial to the query optimizer when it’s determining the best execution plan for a query. In most of the examples I used, if the query di
Announcements, Announcements, Announcements
(Roger Miller) By the time you read this, I expect you will have seen several recent announcements. Rather than concentrating on the latest news, I’d like to highlight two announcements that you might have missed. The first is a no-charge feature that was made available in December 2003. You may
XML for DB2 Information Integration
(Bart Steegmans) In many organizations, relational databases are the backbone for data storage and retrieval. Over the last couple of years, XML has become the de facto standard to exchange information between organizations, as well as between departments or applications within the same organization
Form vs. Function
(Jennifer Kyrnin) The basic premise behind XML and now XHTML is that the markup language should not define how the resulting document will look. The markup language is in the document to define the actual content.
How To Persist an ADO.NET DataSet into XML by Using Visual C++ .NET
You can use the WriteXml method to write XML schema and data from the DataSet object. The XML data is written to a file, a Stream class, an XmlWriter class, or a TextWriter class. You can use one of two sets of overloaded methods for WriteXml, depending on your needs. The first set of four overl
Eternal Refactoring
(Edd Dumbill) Roger Costello dangled an irresistible conversation starter in front of the XML-DEV regulars, the question of whether progress in XML is best served either by simplification or added complexity. The canonical example of simplification driving progress is, of course, XML being a sim
Database 10g Is Crucial to EPA’s Missions
(Peter Coffee) Running Oracle Corp.’s Database 10g on hardware ranging from high-end workstations to field workers’ laptop PCs, the Region 5 Superfund Division of the U.S. Environmental Protection Agency is integrating terabytes of images and measurements into efficient, comprehensive support tools
Oracle Tip: Create functions to join and split strings in SQL
A common task when selecting data from a database is to take a set of values a query returns and format it as a comma delimited list. Another task that’s almost as common is the need to do the reverse: Take a comma delimited list of values in a single string and use it as a table of values. (R)