(Craig Mullins) I have a condition where I have to select only the first row from a SQL query. select b.status from credit_source a,credit b, credit_Status c where a.credit_source_id = b.credit_source_id and b.status = c.status order by c.weight desc fetch first rows only This statement
Other News
Use the flexibility of XEP to render and publish XML presentations
(Kristine Hansen) The engine provides an extra tool for publishing quality XML presentations by essentially creating the “missing link” between XML technology and traditional publishing formats and platforms. XEP, the company’s flagship product, is a formatting engine that takes XML data and parses
List of Database Users with Database Roles
(Santveer Singh) Sometime we come across specific request from our managers or users that needs to explore system tables and database. Today I got the same kind of request from my manager. He needs a list of all database users with database roles. I looked here and there but I didn’t find any he
Oracle lures developers with the promise of a trip into space
(John K. Waters) Oracle is adding some rocket fuel to its tools promotion strategy with a contest that promises to send one lucky developer into space–literally. Announced at the recent Oracle OpenWorld conference (but upstaged by the PeopleSoft acquisition drama), the Oracle Space Sweepstakes give
Interview with Oleksandr ‘Sanja’ Byelkin
(Arjen Lentz) Behind the software of MySQL AB are of course the people. The MySQL developers, and the many other colleagues around them, are the ones who are making it all happen: new features, bug fixes, support, etc. Some of you may have met a few of them already, either at a previous MySQL Users
Database Configuration, the XML Alternative
(Michael Klaene) When creating software, it is a wise decision to separate business logic from information used to configure that software. Over the years, developers have used a number of techniques to externalize configuration. The goal is to make it possible to customize the functionality of a pr
WPC Releases XML Schemas for HIPAA Transactions
Washington Publishing Company (WPC), publisher of electronic data interchange (EDI) transaction implementation guides adopted under HIPAA, has announced the release of W3C compliant XSD, Open Source Schemas, under the GNU license. Created directly from the same database as the federally mandated
Oracle Stored Procedures
(Mooh the Cow) So what’s this business with Oracle allowing programmers to put programs in databases? That’s right. They’re called Oracle stored procedures, and they’re quite useful. The author walks you through writing, creating, debugging, and deleting a procedure.
What Now, Oracle?
(Thomas M. Stockwell) On December 29, 2004, Oracle assumed control of PeopleSoft, the software vendor that merged with J.D. Edwards in 2003. Industry analysts see this as one more example of Larry Ellison’s crass and crafty abduction of IBM territory. Yet, beyond the media circus that surrounded the
Configuration Utility for Application Data Access with DB2 Information Integrator
This utility augments the included tutorial “DB2 Application data access with DB2 II and WBI” by automating the steps necessary for configuring DB2 Information Integrator 8.2, WebSphere Business Integration (WBI) Adapters 2.3.1, and WebSphere MQ 5.3.0.1 to access customer relationship management (CR