易截截图软件、单文件、免安装、纯绿色、仅160KB

Oracle 游标 Cursor 使用

create or replace procedure getok
as
cursor mycur is select ids,name from aaa where name not in (select names from ok);
vempno aaa.ids%type;
vename aaa.name%type;
begin
open mycur;
loop
fetch mycur into vempno,vename;
exit when mycur%notfound;
if mycur%found then
    insert into ok values(vempno,vename);
end if;
end loop;
dbms_output.put_line('I Found You!'||mycur%rowcount||'行');
close mycur;
end getok;
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/lixianzhang0493/archive/2009/12/31/5109682.aspx


相关文档:

Oracle Drop命令

--删除空的表空间,但是不包含物理文件
drop tablespace tablespace_name;
--删除非空表空间,但是不包含物理文件
drop tablespace tablespace_name including contents;
--删除空表空间,包含物理文件
drop tablespace tablespace_name including datafiles;
--删除非空表空间,包含物理文件
drop tablespace table ......

win 7下安装oracle 10g(详细过程)

基本要求
win 7的版本是旗舰版,oracle 10g(Oracle10g第2版10.2.0.3-10.2.0.410203vistaw2k8x86productiondb)迅雷有下载
(搜索“oracle 10g vista”,760MB)
具体过程
1.配置一个虚拟的IP:在安装ORACLE 10g前系统会检测安装的一些前提条件是否满足,
往往会提示说:将Microsoft LoopBack Adapter配置为 ......

oracle 优化之 找出低效率sql 语句

SELECT EXECUTIONS , DISK_READS, BUFFER_GETS,
  ROUND((BUFFER_GETS-DISK_READS)/BUFFER_GETS,2) Hit_radio,
  ROUND(DISK_READS/EXECUTIONS,2) Reads_per_run,
  SQL_TEXT
  from V$SQLAREA
  WHERE EXECUTIONS>0
  AND BUFFER_GETS > 0
  AND (BUFFER_GETS-DISK_READS)/BUFFER_GETS ......

Oracle维护常用SQL语句汇总


 如何远程判断Oracle数据库的安装平台
  select * from v$version;
  查看表空间的使用情况
  select sum(bytes)/(1024*1024) as free_space,tablespace_name
  from dba_free_space
  group by tablespace_name;
  SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
  (B.BYTE ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号