Oracle默认用户密码 视图操作

Oracle默认用户名 和 密码
sys  change_on_install
system  manager
internal oracle
scott tiger

show user; 查看当前用户

passw  修改密码

disc [onnect ]断开连接

show linesize; 显示行数

grant create any view to scott;
create or replace view vw_dept_sum (dname,max,min,avg) as select d.dname,max(e.sal),min(e.sal),avg(e.sal) from emp e,dept  d where e.deptno=d.deptno group by d.dname;

只读 with read only;
create or replace view vw_dept_sum (dname,max,min,avg) as select d.dname,max(e.sal),min(e.sal),avg(e.sal) from emp e,dept  d where e.deptno=d.deptno group by d.dname with read only;

创建简单视图
create or replace view vw_emp as select * from emp;

插入数据(保证deptno数值有效)
insert into vw_emp values(115,'Ouyang','CLERK',7933,'11-04-2012',5400,800,10);

更新数据
update vw_emp set ename='Oyzl' where ename='Ouyang';

删除数据
delete vw_emp where ename='Oyzl';

删除视图
drop view vw_emp;

创建连接视图
create view vw_dept_emp as select d.deptno,d.dname,d.loc,e.ename,e.sal from dept d,emp e where d.deptno= e.deptno and d.deptno in(10,30);

创建复杂视图
create view vw_emp_sal (job,avg,sum,max,min) as select job,avg(sal),sum(sal),max(sal),min(sal) from emp group by job;

强制创建视图
create force view