(Torsten Winterberg and Stefan Scheidt) Oracle JDeveloper has gone through an amazing evolution over the past few years. While older versions were a little bumpy at times, Oracle JDeveloper 10g offers an integrated development environment with substantial features—including modeling, coding, debuggi
Other News
Oracle9i Analytic SQL Features, Part 3
(Brad Cowdrey) This article will take an in depth look at the GROUPING SETS and composite columns through examples including syntax and behavior. In addition, this article will build on the information and examples from the previous articles in the series. All of the examples run off of a base t
MSDE With SQL Web Data Administrator : Authentication
(Scott) Security in computer software applications allows you to control the answer to two critical questions. Who will you grant access to? What operations will you allow them to perform? The first step in answering these questions is determining the identity of the person trying to access the data
Using XML Encryption With CipherReferences, Part 2 – Remote Data
Earlier I posted about using cipher references to refer to data stored in the same document. Today I’ll use the same technique, but instead of storing the encrypted data elsewhere in the document, I’m going to store it on a seperate server. Of course, I’ll be using the familiar order.xml sample to w
32-bit and 64-bit application development with DB2 UDB V8.2
(Gwyneth Evans) If you are migrating from a 32-bit DB2 instance to a 64-bit one, deploying 32-bit applications to 64-bit platforms, or simply want to ensure that you can do so easily later, then this article is for you. We outline DB2 Universal Database’s (DB2 UDB) 32-bit and 64-bit application
PRB: Unable to Display Visual Totals Using the PivotTable Component
When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message: The data source does not support totalling only visible items.
Informix Dynamic Server and DB2 Data Federation
This technote describes how to access and move tables in Informix Dynamic Server (IDS) by using the capabilities of DB2 Data Federation.
Integration Testing
(Dan Sawyer) Integration testing your T-SQL stored procedures saves debugging time and makes database programs more reliable and easier to reuse and maintain. In these respects, integration testing has many of the same benefits as unit testing individual procedures. The big difference between th
Back to School with Database Encryption 101
(Lisa Vaas) Opinion: To fend off criminal manhandling of valuable data, database encryption should be one tool in an enterprise’s arsenal. Database security vulnerability is finally getting a level of attention approaching that which has long been targeted at networks, which is both a good th
Converting Oracle SQL to DB2
(Craig Mullins) I am new to DB2. We are migrating an Oracle database to DB2. In this conversion, I have to convert Oracle SQL to DB2 SQL. (R)