Materialized view

CREATE MATERIALIZED VIEW EMP_MV

BUILD IMMEDIATE

REFRESH COMPLETE

ENABLE QUERY REWRITE

AS SELECT DEPTNO, SUM(SAL) FROM EMP

GROUP BY DEPTNO

refresh method of a Materialized view

exec dbms_mview.refresh('MV1');

Comments

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 ...

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 ...

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, ...

OracleByAjay

Search This Blog