OracleѧϰQQȺ - À©³ä»°Ìâ / ¹àË®ÀÖÔ°
07Äê´´½¨µÄQQȺ£¬½ñÈÕ·¢ÏÖÔÚÒ»Ö±´¦ÓÚÏÐÖÃ״̬¡£½ñÈÕ¾öÐÄÆô¶¯¸ÃȺ¡£48724350¡£¼×¹ÇÎÄѧϰȺ¡£
ºÃ¡£¡£ÖªµÀÁË¡£¡£
ºÃ¡£¡£ÖªµÀÁË¡£¡£
ºÃ¡£¡£ÖªµÀÁË¡£¡£
oracle~
²»¶®oracle°¡£¡£¡
ºÃ¡£¡£ÖªµÀÁË¡£¡£
ÇУ¡
ÿÌì½Ó·Ö£¬ÂýÂýÉýÐÇ¡£
ºÃ¡£¡£ÖªµÀÁË¡£¡£
ÓÑÇéUp£¡~
ÎÒ¶¼ÏÐÖÃÁ˺ü¸¸öÁË¡¡
×î½ü¶ÔÊý¾Ý¿â²»¸ÐÐËȤ
¡£¡£¡£¡£¡£¡£¡£¡£
~~~~~~~~jF
ºÜÉÙ½Ó´¥¼×¹ÇÎĵIJËÄñÄܽøÂð£¿Â¥Ö÷
ѧϰ ѧϰ£¡£¡£¡
ÿÌì½Ó·Ö£¬ÒÔʾ´æÔÚ£¡£¡£¡£¡
ɶ¶¼²»¶®
jf~
jfjf
ºÃµÄÓлú»á½øÈ¥¿´¿´
·Ö·Ö·Ö
Good morning!
ĿǰÓжàÉÙÈËÁË~
Â¥ÏÂľÓÐСJJ.
¸çÊÇÀ´½Ó·ÖµÄ
½Ó·Ö£¬½Ó·Ö¡£
ÓÑÇéUP
Õâ¸öÒª¶¥Ò»ÏÂ
up............................
jf
лл·ÖÏí¡¢
ºÃȺ................
upupupupupupupupupupupupupup
good
1786 ÉýÐÇ
jfjf
ÿÌìjf
¼ÓÈ룬½Ó·Ö
jfjf
ºÆ¶«¶«
ºÇºÇ
»¶ÓÈκÎÈË.´ó¼ÒÒ»Æðѧϰ.
ºÇºÇ¡£ÎÒÖ»ÊÇ˵һ϶øÒÑ¡£´ó¼ÒËæ±ãÁË¡£ÎÒÒ²ÊDzËÄñ¡£ÔÚУѧÉú¡£´ó¼ÒÒ»Æð½ø²½°É¡£Ëµ¾äʵÔڵģ¬Ã»ÓÐʲô×é֯ѧϰ¡£²»Òª¾õµÃºÃÏñÆÁË´ó¼Ò¹ýÈ¥¡£ÖÁÓÚÁÄÌìȺ£¬ÎÒÒ²²»ÖªµÀÁË¡£ <
Ïà¹ØÎÊ´ð£º
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
ÎÒ°²×°ÁËoracle 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......