Oracle Tips and Tricks

Oracle is a database used in a large extent. For more oracle tips and tricks like SQL tips, PL/SQL tips and Oracle DBA, follow IT Blogger Tips.

How to send an E-Mail from 10g Oracle Database

Just follow the below mentioned steps to send an e-mail from Oracle 10g database using …

You can use these best and easy tips to Transpose rows into columns. You can also Transpose columns into rows in Oracle.

The purpose of SQL join is to combine rows from multiple tables. SQL join is …

First create a PLANNING table in oracle using following script. CREATE TABLE PLANNING (CITY VARCHAR2(25), …