Oracle 10g

Jun
22

UTL_MAIL package in Oracle 10g

Tech Guy on June 22nd, 2009

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.

Continue reading about UTL_MAIL package in Oracle 10g

RedditFacebookStumbleuponDiggDel.icio.us Oracle 2 Comments »
Jun
18

Migrating Oracle Database from HP UNIX to LINUX

Tech Guy on June 18th, 2009

This article explains the steps that needs to followed while migrating ORACLE 10g Database from HP UNIX to LINUX platform. This article can also be used for migrating Oracle 10g Database across any platform with slight changes to the steps.

Continue reading about Migrating Oracle Database from HP UNIX to LINUX

Oracle No comments »
Jun
12

Oracle PL/SQL Datatypes

Tech Guy on June 12th, 2009

SQL: Data Types
The following is a list of general SQL datatypes that may not be supported by all relational databases.

Data Type Syntax

Oracle 9i

Explanation (if applicable)

dec(p, s)

The maximum precision [...]

Continue reading about Oracle PL/SQL Datatypes

Oracle No comments »