Case Study:
1) Send an email to an email ID from Oracle whenever an employee’s salary is changed.
2) Spool write a code to store all the results in Spool in SQL Plus.
3) Excel file’s data should be moved to a table.
4) Tables should be put in an Excel file.
5) STUDENTS
SID        SNAME     STATUS
2           ARUN       IN PROGRESS
STUDENT_HISTORY
SID      SNAME     STATUS
1        DINESH     COMPLETED.
The program should be scheduled to be run at 11:00 PM every night.
6) EMAIL                                     PHONE NUMBER
dinesh@gmail.com                 9840496333
Write a program or a script to update all these phone numbers.
7)  Employees
     Department_ID                   Hike Percentage
     90                                           10
     60                                           5
     30                                           7
As shown above Employees Hike percentage should be updated in the table from an excel spreadsheet.
8) Extract data from an xml file and store it to the table in the database. (XML) files is just 1 input and saves a lot of system resources.
9) Send an email to an email ID and a sms to a cell phone number from Oracle whenever an employee’s salary is reduced.
10) After validation Return the user input from the xml file to the user the entire row should be returned to the application developer. 
11) I/P
     CNAME         ORACLE
     DATE           17/NOV/2013
     O/P
STUDENT LIST
SNAME  PHNO  QUALIFICATION
Create a procedure to extract the students list as shown above from the given input.
12) In a given date list all the created objects for that date.