oracleÓÅ»¯ÎÊÌâ
ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ê¹ÓÃÓαê¶ÔÊý¾Ý½øÐвåÈë²Ù×÷£¬Éæ¼°µ½ºÜ¶à±í£¬ÆäÖÐһЩÊÇÖ÷´Ó±í¹ØÏµ£¬°´Ë³ÐòÏÂÀ´£¬Ö÷±íÉú³ÉÊý¾Ý£¬ÔÙÉú³É×Ó±íµÄ¡£ ×î½üÅöµ½Ò»¸öÎÊÌ⣬ÓÉÓÚÓеÄÊý¾ÝÁ¿¹ý´ó£¬Ôì³ÉËٶȺÜÂý£¬ÔÚ10¼¸ÍòÌõÒÔÉÏ¡£ÏëÇë½ÌϸßÊÖ£¬ÓÐûÓкõķ½·¨½øÐÐÓÅ»¯£¬Ìá¸ßÏÂËÙ¶È£¡
ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ËµÕæ²»¶à¡£ Ìù³öSQL¡£ ¶¥£¬¹Ø×¢´ËÀàÎÊÌâ¡£~~~~ÒýÓà ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ËµÕæ²»¶à¡£ Ìù³öSQL¡£ 10Íòʲ»¶à°¡,±í¶à,¹ØÁª¶à,Õâ²ÅÊÇÎÊÌâÒýÓà ÒýÓà 1 Â¥ suiziguo µÄ»Ø¸´:ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ËµÕæ²»¶à¡£ Ìù³öSQL¡£ 10Íòʲ»¶à°¡,±í¶à,¹ØÁª¶à,Õâ²ÅÊÇÎÊÌâ Êǰ¡£¬¾ÍÊÇÒòΪ²Ù×÷µÄ±í±È½Ï¶à£¬ºÜ¶à±íÓÖÓÐÖ÷´Ó¹ØÏµ£¬ÕâÑùÑ»·ÏÂÀ´±È½ÏÂý£¡ ÎÊÌâÌ«·ºÁË,Ö»ÄÜ˵10¼¸ÍòÌõÊý¾Ý²»Ëã¶à Ö÷´Ó±íµÄ¸üÐÂʹÓô¥·¢Æ÷ÊÔÊÔÄØ¡£ Äܲ»Äܲ»ÓÃÑ»·,ÓÃÅúÀï²åÈë,ÏÈÅúÁ¿²åÈëÖ÷±í,ÔÙÅúÁ¿²åÈë×Ó±í,»òÕßÏñ6¥˵µÄÓô¥·¢Æ÷¿´ÏÂ. ×Ö±íÌ«¶àµÄÎÊÌâ°É Äã¹ØÐÄϱíÓë±íÖ®¼äµÄ¹ØÁª·½Ê½~ÒªÈÃSQL¾¡Á¿×îÓÅ£¬Èç¹ûËÙ¶È»¹²»ÐУ¬Äã¾ÍÒª¿¼ÊÔÊý¾Ý¿â½á¹¹ÁË· ºÇºÇ£¬ÎÊÌâÌ«·º·ºÁË ¸øÄãЩÒâ¼û°É£¬¶à¿´¿´ÅúÁ¿²åÈë insert into a select * from b; ÔÚÓоÍÊÇ×¢Òâ±íÓë±íÖ®¼äµÄ¹ØÁªÁË¡£ Äã¿ÉÒ԰ɾßÌåµÄ±í½á¹¹ºÍÐèÇóÄóöÀ´£¬ÎÒÃÇ´ó¼Ò¸øÄã·ÖÎöһϰ¡ FOR rbl_survey_bound in cbl_survey_bound(aFlowSN(i)) loop --»ñÈ¡¾É¿±²âID oldSB_ID := rbl_sur
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......