OracleѧϰQQȺ - Oracle / ·Ç¼¼ÊõÇø
07Äê´´½¨µÄQQȺ£¬½ñÈÕ·¢ÏÖÔÚÒ»Ö±´¦ÓÚÏÐÖÃ״̬¡£½ñÈÕ¾öÐÄÆô¶¯¸ÃȺ¡£48724350¡£¼×¹ÇÎÄѧϰȺ¡£
48724350
ÓÐÈË×é֯ѧϰô,²»ÒªÁÄÌìȺ°¡,ÿÌìÌÖÂÛµãʲôÀ´×Å,
ΪʲôÊǼ׹ÇÎÄ£¿
°ï¶¥........
up!
Ò»°ã¶¼»áÂÙÂä³ÉÁÄÌìȺ
ÒªÊÇÓиöר¼ÒÔÚÀïÃæ¾ÍºÃÁË
ÎÒ¼Óһϣ¡
×îºóµÄ½á¹û¶¼ÊÇÁÄÌìȺ
ºÇºÇ¡£ÎÒÖ»ÊÇ˵һ϶øÒÑ¡£´ó¼ÒËæ±ãÁË¡£ÎÒÒ²ÊDzËÄñ¡£ÔÚУѧÉú¡£´ó¼ÒÒ»Æð½ø²½°É¡£Ëµ¾äʵÔڵģ¬Ã»ÓÐʲô×é֯ѧϰ¡£²»Òª¾õµÃºÃÏñÆÁË´ó¼Ò¹ýÈ¥¡£ÖÁÓÚÁÄÌìȺ£¬ÎÒÒ²²»ÖªµÀÁË¡£
ÓÐ˧¸ç¾Í¼Ó¡£¡£¡£¡£
ÎÒ¸ø´ó¼Ò½éÉÜÒ»¸öѧϰȺ»¹²»´í£¬ÀïÃæ¸ßÊÖҲͦ¶àµÄ£¬QQȺºÅ106331069
¼ÓÎÒһϠ99272553
ѧϰÖÐ
¶÷..Ö§³Ö~
End_rbody_65101809//-->
¸Ã»Ø¸´ÓÚ2010-04-30 16:05:25±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
yuhongpingimu
(ˮľ)
µÈ¡¡¼¶£º
#16Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-04-30 14:30:53
»¹ÓÐ15Â¥¡£Ì«²»ºñµÀ¡£²»»á×Ô¼º¿ªÌù¡£
»¹ÓÐÉùÃ÷£ºÈºÀï²ËÄñ²»ÉÙ£¬²»Ï²ÕßÎð½ø¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......