Database Development Zone

Use SQL Server Triggers to Track Unauthorized Database Changes

SQL Server triggers are a powerful feature, yet they often take a backseat to stored procedures and user-defined functions?a fate they don’t deserve. A trigger can provide an easy-to-implement solution to even the most complicated problem. One task in particular, tracking unauthorized changes in a database, can be transformed from

Database Development in SQLJ

In this series, Oracle Pro Boris Milrud shows you how to use SQLJ, the evolving industry standard language, to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms. SQLJ is a language that allows embedding static SQL statements textually in Java programs.

Using SQL’s EXISTS Predicate to Identify Missing Data

inding data in a relational database is usually a simple task, especially if you’re simply comparing entries to a specific value, but queries rapidly become more complicated when you start hunting for data that’s missing, in other words, data that could exist, but doesn’t. Missing data is data related to

Migrating from SQL Server to Oracle Series

In this series, SQL Server expert Joe Lax will be describing the steps he takes to learn Oracle database administration. Included are editorials, book reviews, and technical articles that chart his course. The content will develop along with Joe’s migration journey, so think of it as a continual work in

Concurrency Handling in Oracle: Preventing Locked Data

ne of the most challenging requirements of a database engine is to react appropriately when two users want the same piece of data at the same time. A well functioning database engine can successfully service thousands of users concurrently. A poor solution will experience noticeable performance degradation as more people

Storing Your Data in Oracle

hat block size did you choose for your database? How many chunks have been allocated for your table? How large is each chunk and what will the size of the next chunk be? If you are a SQL Server DBA, you are probably wondering at this point, “What was that

Why Am I Learning Oracle?

n the last several years, I have built and expanded my career based on my knowledge of Microsoft SQL Server. I’ve used the product as both a database developer and as a database administrator, going so far as to become certified to teach courses on them (MCT) in addition to

Oracle Basics: Querying an Oracle Database

ogging in and querying an Oracle database can be a daunting task for anyone used to SQL Server. Instead of the familiar Query Analyzer tool (see Figure 1), which provides a color-coded syntax, an object browser, multiple windows, and an output grid, you most typically have to contend with Oracle’s

Oracle Has SQL Server Beat in Stored Procedure Programming

oth Oracle9i and SQL Server 2000 support the use of the database as more than a simple data store for your information. They enable you to use the database to implement your business rules and processes as well with enhancements to the standard SQL language that support the more complicated

No more posts to show