(Steve Callan) Oracle provides quite an array of functions when it comes to manipulating data via SQL. The Oracle9i SQL Reference guide (for release 2) lists five categories of SQL functions, with each category containing one or more functions within a category. The major functions are single-row, a
Tag: Oracle
Oracle9i Replication: Multitier Materialized Views
Materialized views, known as snapshots in prior releases, are used to replicate data to non-master sites in a replication environment. Updatable materialized views enable users to maintain data at their local site (even a mobile user with a laptop) and later resynchronize with main site by applying
Managing Exceptional Behavior, Part 2
(Steven Feuerstein) In part 1, I offered suggestions for both an overall exception handling strategy and best practices for raising exceptions in your programs. In this article, I complete my treatment of error handling in PL/SQL, with a look at how best to handle exceptions once they have been rais
A SQL interface for alert log
This is a very handy utility (9i only) which let you query the alert log file from an sql tool (sqlplus/toad /oem …). (script)
Supercharging the Pump
(Jonathan Gennick) New import and export features introduced in Oracle Database 10g, called Oracle Data Pump, represent a radical departure from the client/server approach to which database users have grown accustomed over the past several generations of Oracle Database. The server now runs export a
MSSQL Server 2000 Reporting Services: The Authoring Phase: Overview Part I
(William Pearson) This is the second article of the series MSSQL Server 2000 Reporting Services. The series is designed to introduce MSSQL Server 2000 Reporting Services (“Reporting Services”), with the objective of giving a preview of its features, as well as sharing my conviction in its role as a
Managing Exceptional Behavior, Part 1
(Steven Feuerstein) Many programmers don’t take the time to properly bulletproof their programs. Most of us find it hard enough—and more than enough work—to simply write the code that implements the positive aspects of an application: maintaining customers, generating invoices, and so on. You wr
Using Oracle’s SQL Functions
(Steve Callan) Oracle provides quite an array of functions when it comes to manipulating data via SQL. The Oracle9i SQL Reference guide (for release 2) lists five categories of SQL functions, with each category containing one or more functions within a category. The major functions are single-row, a
Migrating Applications from Microsoft SQL Server to Oracle9i Database
The purpose of this document is to help you migrate your applications when you are migrating the underlying database from Microsoft SQL Server to Oracle9i Database. Most of the issues encountered when migrating applications to use an Oracle9i Database are related to database incompatibility. This pa
Installing Oracle Database 10g on Red Hat Enterprise Linux AS 3 and 2.1, and on Red Hat 9
(Werner Puschitz) The following procedure is a step-by-step guide (Cookbook) with tips and information for installing Oracle Database 10g on Red Hat Linux. Oracle10g is the easiest Oracle on Linux installation so far.