/* 2009/04/18 */
create table DEPT
(DEPTNO number(2),
DNAME varchar2(14),
LOC varchar2(13)
);
insert into dept (deptno, dname, loc)
values(50,'manufacturing','madison');
insert into dept (deptno, dname, loc)
values('six','manufacturing','madison');
alter table dept
add constraint dept_pk
primary key (deptno);
create table EMP
(empNO number(4) constraint emp_pk primary key,
eNAME varchar2(10),
job varchar2(9),
mgr number(4),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2) constraint emp_pk_deptno references dept(deptno)
);
insert into emp (empno, ename, deptno)
values(84, 'JOHNSON', 99);
insert into dept (deptno, dname, loc)
values(99,'research','freeport');
insert into emp (empno, ename, deptno)
values(84, 'JOHNSON', 99);
delete from dept
where deptno=99;
delete from emp
where deptno=99;
delete from dept
where deptno=99;
update dept
set deptno=1
where deptno=10;
drop table dept;
select *
from dept,emp
where dept.deptno=emp.deptno;
select *
from dept natural join emp;
/* catisim ? */
select *
from dept cross join emp;
/* cartesian product */
select *
from dept,emp;
select dname, sum(sal)
from dept, emp
where dept.deptno=emp.deptno
group by dname
having sum(sal)>10000
order by sum(sal);
describe emp;
show all
show sga;
select *
from v$sga;
select component, current_size
from v$sga_dynamic_components;