(Kailash Awati and Arati Apte) This article is a brief introduction to dates in Oracle, with a focus on date manipulation using SQL. The topics I discuss include the following: –Date display formats. –Date arithmetic and date functions.
Author: SSWUG Research
IBM Unveils New Offerings For The Open Source Community
IBM announced new software and resources to help customers leverage their investments in open source development tools and resources. The new offerings will help software development teams build Eclipse-based open integrated development environments that are technologically diverse and vendor neutra
A Job Scheduler Framework for SQL Server Express Edition
(Danilo Corallo) For my last project, I’ve been using the latest free version of SQL Server, called SQL Server Express Edition and available here. I immediately noticed that the database scheduler was removed since the previous version. I found really interesting creating my own SQL Agent. In this a
New UDF to find all files that make up a database
(Chris Eaton) I’ve noticed an increase lately in the popularity of what we sometimes call a split mirror backup. That’s when you use either the storage vendor hardware (like IBM System Storage or EMC Symetrix) or the file system software (like Veritas) to make an instantaneous copy of a set of data
What’s New for Developers in Visio 2007 (Part 2 of 2)
(Saul Candib) This article describes all new objects and members of the Visio 2007 VBA object model and newly deprecated existing members.
Merge XML and Java with XMLBeans in commerce
(Kunal Mittal and Grace Walker) Enterprise architects, faced with ever-increasing levels of software complexity, have zeroed in on Service-Oriented Architecture (SOA) as a means of overcoming system integration problems. Fundamentally, SOA is about improving business results by enhancing the working
RDF Data Model in Oracle
(Nicole Alexander, Xavier Lopez, Siva Ravada, Susie Stephens and Jack Wang) The Resource Description Framework (RDF) is a language for representing information about resources in the World Wide Web. To describe information in RDF, statements are essentially broken into triples: {subject/resource, p
MySQL SQL Syntax and Use
(Paul Dubois) This section discusses some of the important new features that are being developed in MySQL 5.0: –Views –Stored Procedures and Functions –Triggers
Asked & Answered
(Robert Catterall) Q: When a program contains a static SQL statement that references an unqualified table name, how can you know which table will be accessed when your database includes several different tables (same structure, different data) that have the same unqualified name but different high-l
Displaying drill down rows in datagrid
(Yes’B) In my recent project I come across a problem of displaying drill down rows in a DataGrid. It has to show a new row immediately after the selected row to accept that row information.