Notes

DROP VIEW viewEmpSal;
DROP SYNONYM vSal;

--A.)
--dbm cfg;
--update db cfg for sample using LOG52 512;
--B.

--1.


--a.)
connect to Sample;
--b.)
CREATE TABLE Dept (Deptno INTEGER not null, Dname VARCHAR(30) not null, Loc VARCHAR(40));
CREATE TABLE Emp (Empno INTEGER not null, Ename VARCHAR(30), Job VARCHAR(15), Salary

DECIMAL(8,2) not null);
--c.)
DESCRIBE TABLE Dept;
DESCRIBE TABLE Emp;
--d.)
INSERT INTO Dept (Deptno,Dname,Loc) values
(1,'Marketing','Manila'),
(2,'Sales','Quezon City'),
(3,'HR','Makati');
INSERT INTO Emp (Empno,Ename,Job,Salary) values
(100,'DELA CRUZ, JUAN','Manager',20000),
(101,'SANTOS, MARY','Secretary',12000),
(102,'YU, SAM','Programmer',18000);

--e.)
SELECT * FROM Dept;
SELECT * FROM Emp;
--f.)
CREATE VIEW viewEmpSal AS SELECT Empno,Salary FROM Emp;
--g.)
CREATE SYNONYM vSal FOR viewEmpSal;
--h.)
SELECT * FROM viewEmpSal;
SELECT * FROM vSal;
--i.)
DROP TABLE Emp;
DROP TABLE Dept;
DROP VIEW viewEmpSal;
DROP SYNONYM vSal;