Oracle Warehouse Builder is Primarily a tool to build, deploy, and run ETL (Extract, Transform, Load), relational and dimensional modeling, data quality, data auditing, and full lifecycle management of data and metadata. OWB powers ETL and data quality integrated with the Oracle Database.
Tags: data warehouse, ETL, Extract Loand Transform, oracle warehouse builder, OWB
UTL_MAIL Package in oracle 10g is used to send email programmatically from Oracle PL/SQL procedures. This tutorial explains how to use the package to send email.
Tags: oracle 10g, oracle mail package, oracle package, utl_mail, utl_mail package
primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
Oracle PL/SQL: Oracle System Tables. Below is an alphabetical listing of the Oracle system tables that are commonly used.
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement. This tutorial is a continuity of Oracle PL/SQL Cursors which discuses some basic functionalities of PL/SQL Cursors.
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement.
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
Oracle PL/SQL: Commit Transactions
The syntax for the COMMIT statement is:
COMMIT [WORK] [COMMENT text];
The Commit statement commits all changes for the current session. Once a commit is issued, other users will be able to see your changes.
Oracle PL/SQL: Rollback Transactions
The syntax for the ROLLBACK statement is:
ROLLBACK [WORK] [TO [SAVEPOINT] savepoint_name];
The Rollback statement undoes all [...]
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
In Oracle, you can create an autonumber field by using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
This article contains tutorial about Oracle PL/SQL Loops and Conditional Statements. Following topics are discused here IF-THEN-ELSE Statement, Case Statement, GOTO Statement, Loop Statement, FOR Loop, CURSOR FOR Loop, While Loop, Repeat Until Loop and Exit Statement
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
In other languages, a null value is found using the = null syntax. However in PLSQL to check if a value is null, you must use the "IS NULL" syntax.
To check for equality on a null value, you must use "IS NULL".
For example,
IF Lvalue IS NULL then
.
END IF;
If Lvalue contains a null value, [...]
Tags: oracle plsql, oracle tutorial, plsql, plsql tutorial
