03Oracle数据库对象教程.pptVIP

闫峻 PhoneEmail;回顾;回顾;本章目标;Oracle的SQL开发工具;什么是 SQL Developer ;创建连接 ;数据库对象简介;数据库对象简介;浏览对象 ;创建对象 ;修改对象 ;编辑 PL/SQL;用户User;表Table;表Table;约束Constraint;约束Constraint;约束Constraint;序列;访问序列;更改和删除序列;序列Sequence;视图;视图的优点;视图;创建视图;视图View;创建视图;联接视图;联接视图;视图上的DML语句;键保留表;视图中的函数;同义词;同义词;同义词Synonym;同义词;同义词;同义词;标准表的表和索引管理;索引;索引Index;索引Index;索引;索引;唯一索引;组合索引;反向键索引;位图索引;B 树的结构图;位图索引;基于函数的索引;PL/SQL Developer;PL/SQL Developer;以空间来换取时间;索引Index优化的规则;索引Index优化的规则;举例1;索引Index优化的规则;索引Index优化的规则;举例2;举例3;数据字典;数据字典;数据字典;数据字典;数据字典;数据字典; LOB大对象的处理;LOB大对象;Strust2处理LOB;result name=success type=stream param name=contentTypeimage/jpeg/param param name=inputNameinputStream/param param name=bufferSize8192/param /result public InputStream getInputStream(){ Aa aa=(Aa)session.get(Aa.class,id); return aa,getPhoto().getBinaryStream(); };提问时间;总结;总结;Thank you very much!;练习1;求购买供应商“宝洁”产品的所有顾客 select from purcase a, product b, customer c Where ductid=ductid and c.cid=a.cid 求牙膏卖出数量最多的供应商 create or replace view aa as select provider, sum(quantity) as tot from product a, purcase b where ductid=ductid and a.catalog=‘牙膏’ group by provider select provider,tot from aa where aa.tot=(select max(tot) from aa);;求购买的商品包含了顾客dennis所购买的所有商品的顾客姓名 select name from customer aa where not exists(select ductid from purcase a, customer b where a.cid=b.cid and =‘dennis’ minus select ductid from purcase a,customer b where a.cid=b.cid and = and ’dennnis’);;将所有的牙膏商品单价增加10% update product set price=price*1.1 where catalog=‘牙膏’； 删除从未被购买的商品记录 delete from product a where not exists(select * from purcase where productid=ductid);;练习2;本章结束;作业;要求