Trigger :old and :new concept

CREATE TABLE AUDIT_EMP

(RCD DATE, EMPID NUMBER(4), old_salary NUMBER(7,2), new_salary NUMBER(7,2)

);

SELECT * FROM AUDIT_EMP;

CREATE OR REPLACE TRIGGER audit_emp_values

AFTER DELETE OR INSERT OR UPDATE ON emp

FOR EACH ROW

BEGIN

INSERT INTO audit_emp

VALUES ( SYSDATE, :OLD.empno,:OLD.sal, :NEW.sal );

END;

UPDATE EMP SET SAL = SAL+100 WHERE EMPNO =7369;

SELECT * FROM AUDIT_EMP;

Comments

PL / SQL practice programs

PL / SQL practice programs 1. Write a program to print the following format WELCOME TO PL/SQL PROGRAMMING BEGIN DBMS_OUTPUT.PUT_LINE('WELCOME TO PL/SQL PROGRAMMING'); END; / 2. Write a program to print the numbers from 1 to 100 DECLARE N NUMBER(3):=1; V VARCHAR2(1000); BEGIN WHILE N <=1000 LOOP V:=V||''||N; N:=N+1; END LOOP; DBMS_OUTPUT.PUT_LINE(V); END; / 3. write a program to print the even numbers from 1 to 100 DECLARE N NUMBER(3):=0; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 4. Write a program to print the odd numbers from 1 to 100 DECLARE N NUMBER(3):=1; BEGIN WHILE N <=100 LOOP N:=N+2; DBMS_OUTPUT.PUT_LINE(N); END LOOP; END; / 5. write a program for multiplication table DECLARE A NUMBER(2):=&A; B NUMBER(2):=1; C NUMBER(3); BEGIN WHILE B <

RDBMS MINI PROJECT

Capgemini class room training. RDBMS MINI PROJECT ( SPRINT ) LIBRARY MANAGEMENT SYSTEM Table of Contents Serial No. Topic Name Content Page No. 1. Introduction 1.1 Setup checklist for mini project 3 1.2 Instructions 3 2. Problem statement 2.1 Objective 4 2.2 Abstract of the project 4 2.3 Functional components of the project 4 2.4 Technology used 5 3. Implementation in RDBMS LOT 3.1 Guidelines on the functionality to be built 6 4. Evaluation 4.1 Evaluation 7 1. Introduction This document outlines a mini project for the RDBMS LOT

sample tables

--sample tables DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; DROP TABLE DUMMY; CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20); INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30); INSERT INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30); INSERT INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-APR-1981', 'DD-MON-YYYY'), 2975, NULL,

OracleByAjay

Search This Blog