ÇëÎÊÏÂѧϰoracleµÄ²½Ö裬×îºÃÄܹ»ÍƼöϺõãµÄÊéŶ£¡£¡ÊDz»ÊÇÏȰÑlinuxѧºÃÔÙѧ£¿£¿Âé·³¸÷λ°ïÖúСµÜÒ»ÏÂŶ£¡Å¶£¡£¡Ð»Ð»ÁËŶ£¡
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî)
È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éoracleµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã± ......
ÏÖÔÚÎÒÓÐÒ»¸öÒÉÎÊ£ºÔÚscott/tigerÓû§Ï£¬Ð޸ıíEMP£¬½«Ã¿¸ö²¿Ãʤ×Ê×î¸ßµÄÔ±¹¤Ð½Ë®Ìá¸ß500¿éÇ®
ÎÒµÄSQLÓï¾äÊÇ£º
SQL code:
SQL> update emp2
2 set sal=sal+200
3 where empno in
4 (select empno
5 from ( select *
6 from (select emp.*,row_number() over(partition by d ......
oracleÖÐÓÐûÓÐÏñjava finallyÒ»ÑùµÄ¹Ø¼ü×Ö°¡¡£¾ÍÊÇÎÞÂÛʲô¶¼Ö´ÐС£
±ÈÈ磬ÎÒÓÐÒ»ÕűíÖÐÓÐÊý¾Ý£¬ÎÒҪɾ³ý±íÖеÄÊý¾Ý£¬ÔÚ´æ´¢¹ý³ÌÖС£×öÁËһϵÁеIJÙ×÷ºó£¬ÎÒҪɾ³ýÊý¾Ý¼´Ê¹ÊÇÓÐÒì³££¬Ò²ÒªÉ¾³ý¡£
ûÓУ¬Äã¿ÉÒÔдÔÚÒì³£´¦ÀíÀïÃæ
begin
do finally;
exception
when .. then
do finally;
end;
......
ÎÒÏëÇóµÃ×Ö·û´®ÐÍÖµµÄ³¤¶È£¬ÇëÎÊÔÚdb2 8ÓÐûÓÐÀàËÆoracleµÄlength¡¢lengthbº¯Êý£¬Ð»Ð»¸÷λÁË
×·ÎÊÒ»¾ä£ºdb2 8µÄto_dateº¯ÊýÔõôÓ𡣬ÕâÑù×ÓºÃÏñ²»Ðа¡:to_date('25-12-2009','dd-mm-yyyy')
http://topic.csdn.net/u/20090525/11/94059A1F-C2ED-42F2-AF28-417120FF4848.html
http://topic.csdn.net/ ......
weblogicÔÚoracleÊý¾Ý¿âÐÞ¸Ä×ֶκó£¬ÐèÒªÖØÆô
Äܲ»ÖØÆôÂð£¿
¿ÉÒÔÁ¬ÉÏÊý¾Ý¿â
ûÈËÖªµÀÂð ²»ÒªÁßÉ«°¡
ÐèÒªÖØÆô°É£¡£¡£¡
ÖÁÉÙÐèÒªÒ»¸öÖØÐ·¢²¼µÄ²Ù×÷°É£¬ÒòΪDAO²ãÒѾ·¢ÉúÁ˱仯¡£
Â¥Ö÷£¬Äú¸²¸ÇµÄÔÒòÎÒ¾õµÃÓ¦¸ÃÊÇÊý¾Ý¿âÐÞ¸ÄÁËÏàÓ¦µÄ×ֶΣ¬¶øÄãµÄappÉæ¼°µ½¸Ã×ֶεÄÏà¹Ø´úÂëÐèÒªÐÞ¸ÄÒÔ±£Ö¤ºÍÊý¾Ý¿âµÄ×ֶζÔÓ¦£ ......
ÎÒÏë×î¼òµ¥µÄÊÇͨ¹ýUAÀ´Çø·Ö£¬µ«ÊÇÎÒ·¢ÏÖץȡ²»Í¬ÊÖ»úʱ£¬ÓеĿÉÒÔ»ñµÃUA£¬ÓеľͲ»ÄÜ»ñµÃ£¬»¹ÓÐÆäËûʲô·½Ê½¿ÉÒÔÅжÏÊÖ»úÐͺÅÂð£¿WAP³ÌÐòµÄ
ÒÔÏÂÊÇÎÒ»ñµÃµÄÇëÇóÍ·ÐÅÏ¢£¬ºóÃæ¸½»ñÈ¡³ÌÐò
¶àÆÕ´ïS1 IE£º
accept:text/html; text/vnd.sun.j2me.app-descriptor, */*
accept-language:zh-cn
ua-os:Windo ......