Advertisment

Using Business Rules to Define Decision Points

Wwe will look at how we can use the Business Rules engine to externalize rules from a BPEL process into a separate decision service, and then once...

Views: 5747 | | by Duane Moraes
Oracle - Miscellaneous

Oracle SQL*Plus

A beginners tutorial for Oracle SQLPlus.

Views: 1544 | | by Sean
Oracle - Miscellaneous

Oracle DBA Tutorial Part 1

In part one of our Oracle DBA 1Z0-0001 lessons we will learn how to handle null values and how to concatenate columns amongst other topics.

Views: 1478 | | by John
Oracle - Miscellaneous

Joining Tables

In our third Oracle DBA lesson we discuss joining tables together and joining tables to themselves.

Views: 1569 | | by Source
Oracle - Miscellaneous

Advanced Replication

Advanced replication allows the simultaneous transfer of data between two or more Master Sites. Each Master Site is fully functional and...

Views: 1448 | | by Source
Oracle - Miscellaneous

Fixing UTL_SMTP, UTL_TCP, et.al. in Oracle 8i

When installing Oracle 8i, if you choose to create your database manually, the UTL_TCP suite of Java classes aren't installed causing all...

Views: 1532 | | by Marry
Oracle - Miscellaneous

Installation of ORACLE 7 on SCO Unix

This document explains how to install Installation of ORACLE V 7.0.16.4.0 for SCO Unix on Linux V 1.2.1

Views: 1495 | | by Sarah
Oracle - Miscellaneous

Installing Oracle 8 Solaris-Sparc

This technical document will take you through a step by step process for installing Oracle 8 / EE on Solaris for Sun Sparc boxes.

Views: 1519 | | by Nick
Oracle - Miscellaneous

Installing Oracle 9i on RedHat Linux

Step by step instructions on how to install Oracle 9i on RedHat Linux 7.1, 7.2, 7.3, 8.0 and 2.1 Advanced Server

Views: 1555 | | by John
Oracle - Miscellaneous

Oracle 101

An overview of Oracle illustrated with several examples. Content includes advanced techniques for database administration and PL-SQL programming.

Views: 1450 | | by Stephen
Oracle - Miscellaneous

Rebuilding Oracle8 Object Types

How can I rebuild an Oracle8 object type if it has table dependencies? Hey, that's a great question. Unfortunately, I haven't found a...

Views: 1504 | | by Slicer
Oracle - Miscellaneous

Connecting to Oracle 9 using the Microsoft .NET Framework

In this Tip we show how to connect to an Oracle 9.2.0 database from the .NET Framework using C#, MDAC and ODBC

Views: 1439 | | by Stephen
Oracle - Miscellaneous

Introduction and Examples to Oracle Advanced Queueing

Oracle introduced powerful queuing mechanisms where messages can be exchanged between different programs. They called it Advanced Queuing AQ....

Views: 1426 | | by Ben
Oracle - Miscellaneous

Global Statistics vs. Histograms with DBMS_STATS Package

Optimisation is the process of choosing the most efficient way to execute a SQL statement. The cost-based optimiser uses statistics to calculate...

Views: 1508 | | by Slicer
Oracle - Miscellaneous

The Secrets of Materialized Views

In this article you'll find out what materialized views are, what they can do and, most importantly, how they work - a lot of the ' magic...

Views: 1440 | | by Steve
Oracle - Miscellaneous

Analytic Functions in Oracle 8i and 9i

Analytic Functions, which have been available since Oracle 8.1.6, are designed to address such problems as 'Calculate a running total',...

Views: 1515 | | by Jason
Oracle - Miscellaneous

Parallel Clause and Small Tables

If you have multiple CPUs available you may come up with the idea to set parallel execution on every table. The Oracle Optimizer should decide...

Views: 1413 | | by Sarah
Oracle - Miscellaneous

How to specify the WHERE clause for UPDATE / DELETE

Sometimes multiple users are accessing the same tables at the same time. In these situations, you need to decide when to allow your application to...

Views: 1490 | | by Mark
Oracle - Miscellaneous

How to measure Index Selectivity

B*TREE Indexes improve the performance of queries that select a small percentage of rows from a table. As a general guideline, we should create...

Views: 1426 | | by Donald
Oracle - Miscellaneous

Primary Keys and Unique Columns in Oracle and SQL-Server

The SQL-92 standard requires that all values in a primary key be unique and that the column not allow null values. Both Oracle and Microsoft SQL...

Views: 1590 | | by Jason
Oracle - Miscellaneous