随笔分类 -  oracle

摘要：ORACLE PL/SQL编程之把游标说透http://kb.cnblogs.com/page/100461/ORACLE PL/SQL编程之把过程与函数说透http://kb.cnblogs.com/page/100144/ORACLE PL/SQL编程之把触发器说透http://kb.cnblogs.com/page/99328/ 阅读全文

摘要：1、创建视图CREATE OR replace VIEW my_view(id,stuname,stupassword)) AS SELECT s.id,s.stuame,item.stupassword FROM stu s,stu_item item WHERE item.fid=stu.id;2、使用视图SELECT * FROM my_view WHERE stuname='testname';3、查看视图创建语句SELECT TEST FROM my_view4、游标的创建和使用DECLARE CURSOR my_cur IS SELECT * FROM stu st 阅读全文

摘要：1、创建一个表，同时插入一些数据create table empTemp as select * from emp where sal>1000;2、清空表数据truncate table empTemp;3、删除表drop table empTemp;4、增加表的字段alter table empTemp add tempName varchar2(50);5、修改字段alter table empTemp tempName varchar2(10);alter table empTemp column rename tempName to tempName2;6、删除字段alter 阅读全文

摘要：SELECT * FROM jf_applymain p WHERE (p.cardid,p.acceptdate) IN ( SELECT j.cardid,MAX(j.acceptdate) FROM jf_applymain j WHERE j.isupdated ='1' GROUP BY j.cardid)AND p.syear = (select to_char(sysdate,'yyyy') as nowYear from dual)ORDER BY p.acceptdate DESC得到年份(select to_char(sysdate,' 阅读全文