(Lewis R Cunningham) This tip will answer two questions I get very frequently. Definitely a FAQ. “How do I retrieve and use the VARCHAR2 index of an associative array?” and “How can I sort a PL/SQL table?” These questions pertain to PL/SQL functionality; not SQL functionality.
Author: SSWUG Research
Oracle’s New Partner Path
(Barbara Darrow) In its latest attempt to navigate the tricky waters of direct and indirect sales models, Oracle is experimenting with new All Partner Territories.
Difference between two dates in hours
(Brian Peasland) How do you calculate the difference between two dates in hours? (R)
DB2 9 Fundamentals exam 730 prep, Part 7: Introducing XQuery
(C. M. Saracco) DB2 9 features support for XQuery, an industry-standard language designed expressly for querying XML data. With XQuery and DB2 9 you can retrieve entire XML documents or XML fragments stored in XML columns. You can also specify XML-based filters for queries, transform XML output, and
FIX: You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4
Consider the following scenario. You upgrade from Microsoft SQL Server 2000 Service Pack 3 (SP3) to Microsoft SQL Server 2000 Service Pack 4 (SP4). Then, you run a query that uses the UNION ALL operator. In this scenario, you may notice a decrease in performance.
Perform point-in-time table-level restore in Informix Dynamic Server
(Doyun Kim) This article describes how to perform point-in-time table-level restores that extract tables or portions of tables from archives and logical logs. Table-level restore is a new feature for IBM Informix Dynamic Server Version 10.0. This feature is useful where portions of a database, a tab
To clarify – MDC and MQTs can be used in DB2 Express-C
(Fred R. Sobotka) You’ll thank me for not coming up with some cutesy title for this post. It’s been a bit frustrating to see such a powerful DBMS hit the market for free, only to get murky, contractictory coverage regarding important details. If you are among the many who are utterly confused about
XPath Support in Browsers
(Nicholas C. Zakas) Because XML is used for so many kinds of data, it became necessary to create a means to locate data inside of XML code. The answer to this problem is XPath, which is a small language used specifically to locate a single node or multiple nodes that match a particular pattern.
Explore how SQL Server’s system databases work
(Tim Chapman) A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine’s system databases. It’s also useful for database developers to be up on system databases packaged with SQL Server. Here’s a rundown of the system databases. (Note: If you decide to explore t
Applying a watermark to a Textbox in a Web Application
(Deobrat Singh) You may have seen some web sites displaying watermarks in text boxes. As soon as you click on a text box, the watermark disappears and you can start entering text. In this article, I will explain a small JavaScript trick that you can use to do the same in your web application. I have