telnet to giraffe.uvm.edu

acct: train01 - 06

pwd: 030402

after logging on to giraffe,

type

envwhsx

That set's the "current instance" to the

test Warehouse instance which is where we are

playing.

Then type

sqlplus /

select ename, dname from emp, dept

where emp.deptno = dept.deptno

and sal >= 3000;

select count(*) from emp;

select sum(sal) from emp;

select sum(sal) from emp

group by deptno;

select emp.deptno, sum(sal)

from emp, dept

where emp.deptno = dept.deptno

group by emp.deptno;

select a.ename, b.ename

from emp a, emp b

where a.mgr = b.empno;

create view manager

as (select a.ename employee, b.ename manager

from emp a, emp b

where a.mgr = b.empno);

select ‘update emp set sal = sal * 1.10

where empno = ‘||empno from emp;

select ‘update emp set sal = sal * 1.10

where empno = ‘||empno||’;’ name from emp;

select select ‘update emp set sal = sal * 1.10

where empno = ‘||empno||’;’ name from emp;tno

select deptno, count(*)

from emp

group by deptno;

select deptno, count(*)

from emp

group by deptno

having count(*) > 3;

select ‘’’’||ename||’’’,’’’||sal||’’’’

from emp;