Best Tutorials website
Latest tutorials

Advertisment

Using Business Rules to Define Decision Points

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: 1360 | Rating star | by Duane Moraes
Oracle - Miscellaneous

Oracle SQL*Plus

Oracle SQL*Plus

A beginners tutorial for Oracle SQLPlus.


Views: 513 | Rating star 3 | by Sean
Oracle - Miscellaneous

Oracle DBA Tutorial Part 1

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: 477 | Rating star | by John
Oracle - Miscellaneous

Joining Tables

Joining Tables

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


Views: 483 | Rating star | by Source
Oracle - Miscellaneous

 Advanced Replication

Advanced Replication

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


Views: 444 | Rating star | by Source
Oracle - Miscellaneous

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

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: 467 | Rating star | by Marry
Oracle - Miscellaneous

 Installation of ORACLE 7 on SCO Unix

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: 434 | Rating star | by Sarah
Oracle - Miscellaneous

 Installing Oracle 8 Solaris-Sparc

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: 461 | Rating star | by Nick
Oracle - Miscellaneous

Installing Oracle 9i on RedHat Linux

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: 461 | Rating star | by John
Oracle - Miscellaneous

Oracle 101

Oracle 101

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


Views: 463 | Rating star | by Stephen
Oracle - Miscellaneous

Rebuilding Oracle8 Object Types

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: 464 | Rating star | by Slicer
Oracle - Miscellaneous

Connecting to Oracle 9 using  the Microsoft .NET Framework

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: 452 | Rating star | by Stephen
Oracle - Miscellaneous

Introduction and Examples to Oracle Advanced Queueing

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: 459 | Rating star | by Ben
Oracle - Miscellaneous

Global Statistics vs. Histograms with DBMS_STATS Package

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: 497 | Rating star | by Slicer
Oracle - Miscellaneous

The Secrets of Materialized Views

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: 445 | Rating star | by Steve
Oracle - Miscellaneous

Analytic Functions in Oracle 8i and 9i

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: 458 | Rating star | by Jason
Oracle - Miscellaneous

Parallel Clause and Small Tables

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: 397 | Rating star | by Sarah
Oracle - Miscellaneous

How to specify the WHERE clause for UPDATE / DELETE

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: 457 | Rating star | by Mark
Oracle - Miscellaneous

How to measure Index Selectivity

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: 444 | Rating star | by Donald
Oracle - Miscellaneous

Primary Keys and Unique Columns in Oracle and SQL-Server

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: 418 | Rating star 3 | by Jason
Oracle - Miscellaneous