Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;

--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace procedure PR_TEST_CURSOR
(JOBID IN VARCHAR2,cur_test out pk_test.cur_test)
as 
begin
open cur_test for select ENAME,JOB from emp where JOB=JOBID;
end;

--ͨ¹ý¹ý³Ìµ÷ÓÃÉú³ÉÓαê(ºìÉ«²¿·Ö£©£¬²¢ÀûÓÃÓαê´òÓ¡.
declare 
  type t_name is table of scott.emp.ename%type;
  type t_job is table of scott.emp.job%type; 
  cr_test pk_test.cur_test;
  e_name t_name;
  e_job t_job;
begin
--open cr_test for select ename,job from emp where job='MANAGER';
  PR_TEST_CURSOR('MANAGER',cr_test);
  fetch cr_test BULK COLLECT
  INTO e_name, e_job;
  CLOSE cr_test;
  
  for i in e_name.first..e_name.last loop
  dbms_output.put_line(e_name(i)||e_job(i));
  end loop;  
end;


/*
ÎÊÌ⣺ÒÔÉϵ÷ÓÃÊÇÓÐÎÊÌâµÄ,ÎÞ·¨Ê¹Ó㬱¾ÈËÊdzõѧÕߣ¬¾õµÃÕâÑùµÄµ÷ÓÃÓ¦¸ÃÊÇûÎÊÌâµÄ°É£¡
Çë´ó¼Ò°ïæ½âÎò£¡
*/

fetch cr_test BULK COLLECT
  INTO e_name, e_job;


ÕâÀïÓ¦¸ÃÓÃpl/sql±í£¬Ò»¸ö±äÁ¿Ò»´ÎÖ»ÄܽÓÊÕÒ»¸öÖµ£¬²»ÄÜfetch BULK COLLECT

ÒýÓÃ
fetch cr_test BULK COLLECT


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.

XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ