(Melonfire) In SQL terms, a trigger is “procedural code that is automatically executed in response to certain events on a particular table in a database” (Wikipedia). More simply, it is a stub of code that is automatically activated when a particular database event, such as an INSERT or DELETE, occu
Author: SSWUG Research
Introduction to .Net Framework 2.0 Nullable Types
(Muhammad Mosa) Have you ever needed to add a null value to your integer, date & time,decimal or Boolean etc… data types?! I’m sure you may faced this desire before and you had to work around it to submit null value to those value data types. For example using DateTime.MinValue as a mark to a null
An Introduction to Using the Decorator Pattern with PHP
(Alejandro Gervasio) A decorator class allows you to add more capacity to an existing class while leaving the original class untouched. It has certain advantages over inheritance, as you will learn in this first article of a three-part series.
Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB)
(Lewis R Cunningham) A BOOLEAN datatype is a native PL/SQL type that lets you signify a TRUE or FALSE condition. A BOOLEAN is NULL until explicitly assigned a value.
Build an Error-Submission System for Your JavaScript/AJAX App Users
(Greg Travis) End-user JavaScript bugs would be easier to debug if you had access to the end-user’s computer. Since you don’t, you can do the next best thing: get users to send you what you need to fix the problem.
XML and Related Technologies certification prep, Part 1: Architecture
(Mark Lorenz) A software system’s architecture and performance requirements affect your decision of which XML technologies are most appropriate for your application’s needs. This tutorial on architecture teaches you how to discern where and when to use XML in system design. It is the first tutorial
Oracle SQL Aggregation Extensions
(Kailash Awati and Arati Apte) This article is introduces Oracle’s CUBE and ROLLUP extensions to the GROUP BY clause. The schema and sample data population scripts that accompany the discussion can be accessed here.
Extending the .NET Console Interface
(Jim Mischel) I’ve always had a fondness for character mode applications, both aesthetically and technically. A well-designed character mode application reminds me of my early days plugging away on the Radio Shack TRS-80 or my old Osborne I. In addition to plain text output for processing programs,
Programmatically Creating Context-Sensitive Help on a Web Page
(Scott Mitchell) In last week’s article, Creating Context-Sensitive Help on a Web Page, we looked at how to associate rich help "tooltips" with certain regions in the browser. With a bit of client-side JavaScript and HTML markup, this previous article illustrated how to have a help window with image
FIX: Error message when you run the SQLDiag utility or the PSSDiag utility: ‘Exception creating Perfmon log’
When you run the SQLDiag utility or the PSSDiag utility to collect Performance Monitor (PerfMon) counters, you may receive the following error message: Exception creating Perfmon log