Blog Posts

Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide

March 3, 2015

Learn how to configure email notifications for Oracle Scheduler jobs. This guide covers SMTP server setup, defining default senders, creating jobs, and setting up job notifications for proactive monitoring.
Trigger to backup the data before delete or update on a table – Oracle

February 10, 2015

Lets create a table : CREATE TABLE “ABC” ( “EMPNO” NUMBER(4,0), “ENAME” VARCHAR2(10 BYTE), “JOB” VARCHAR2(9 BYTE), “MGR” NUMBER(4,0), “HIREDATE” DATE, “SAL” NUMBER(7,2), “COMM” NUMBER(7,2), “DEPTNO” NUMBER(2,0) ) TABLESPACE “USERS” ;Now we will insert some data into it :Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,’SMITH’,’CLERK’,7902,to_date(’17-DEC-80′,’DD-MON-RR’),800,null,20);Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,’ALLEN’,’SALESMAN’,7698,to_date(’20-FEB-81′,’DD-MON-RR’),1600,300,30);Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7521,’WARD’,’SALESMAN’,7698,to_date(’22-FEB-81′,’DD-MON-RR’),1250,500,30);Insert into ABC…
Generating Random Data in Oracle Tables for Testing

January 21, 2015

Learn how to use Oracle’s DBMS_RANDOM package to generate random test data for your tables. This guide covers random strings, numbers, and dates with PL/SQL examples.
How to Resolve TNS-03505: Failed to Resolve Name Error in Oracle

November 19, 2014

Learn how to troubleshoot and resolve the Oracle TNS-03505: Failed to Resolve Name error. This article covers common causes, step-by-step troubleshooting, and best practices for ensuring a successful Oracle connection.
Fixing ORA-31633: Unable to Create Master Table During Data Pump Import

November 14, 2014

Learn how to resolve the ORA-31633: Unable to Create Master Table error in Oracle Data Pump Import. This guide covers troubleshooting steps, necessary privileges, and best practices to ensure a successful import.