oracleÊý¾Ý¿âתmysql
oracleÌ«¹óÁË,Áìµ¼Èû»³Émysql ÔÀ´µÄoracleÊDz¼ÖÃÔÚlinux·þÎñÆ÷ÉÏ,¿Í»§¶ËÓÃBCB¿ª·¢µÄ,ÔÚwindowsÏÂÔËÐÐ,µ«ÔËÐеĻúÆ÷ÉϱØÐë×°Ò»¸öoracleµÄ¿Í»§¶Ë ¿´ÁËÏ´úÂë,³ÌÐòÊÇͨ¹ý²éÕÒoracle¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý»ñµÃÁ¬½Ó×Ö·û´®µÄ... ÕâÖÖ³ÌÐòת³ÉmysqlµÄ»°ÐèÒª¸ÄʲôµØ·½?
Ó¦¸ÃÐèÒª¸ÃºÜ¶àµØ·½°É£¬¾ßÌå²»ÊǺܶ®£¬°ï¶¥ Êý¾Ý¿â°²×°µÄʱºòÓд洢¹ý³Ì... רÓÐsqlÄܾÙÀý˵Ã÷ô£¿ÒýÓà Á¬½Ó²¿·ÖÓÃODBC»¹²»ÐÐ bcbÓÃODBCÁ¬½ÓmySql ÐèÒªÏÂÔØMySqlµÄ myODBCÇý¶¯ ÕâÑù²Å¿ÉÒÔ Èç¹û²»ÓÃÕâÑùµÄ·½Ê½ ¿ÉÒÔÊÔÒ»ÏÂÓÃmysql++ for bcbµÄAPI ²»¹ý×îºÃ»¹ÊÇÈ¥Ñý¸çµÄÍøÕ¾ÉÏÏÂÄǸöÆÆ½âµÄmyDAC ×°ºÃÖ»ÓÐÖ±½ÓÓÐÖ§³ÖÁ¬½ÓmysqlµÄ¿Ø¼þ ºÜ·½±ã лл... Ò»ÏÂÌṩÈýÖÖ·½Ê½... ¸Ï¿ìѧϰһÏÂ... Ŀǰ²ÉÓõÄÊÇBDEµÄ·½Ê½ BDEÖ§³Ömysqlô? Ó¦¸ÃÊÇÖ§³ÖµÄ°É,ÓÐûÓз½·¨¿ÉÒÔ²»¸Ä±äĿǰʹÓÃBDEµÄ·½Ê½ myDACÃ²ËÆÊǰÑBDE¸øÊ¡µôÁË ³ÌÐòºÜ´ó,Óõ½Á˺ܶàTQuery,ÕâÑùµÄ»°×ª³ÉdbExpress»òÕßADO·½Ê½ÊDz»ÊÇÒ²Òª»»³ÉÏàÓ¦µÄQuery£¬Èç¹ûÊÇÕâÑùµÄ»°»áºÜ·±Ëö... ¿´À´Ö»ÄܲÉÓÃBDE+ODBCµÄ·½·¨ÁË Ê¹ÓÃÕâÖÖ·½·¨µÄ»°,Óн̳ÌÖ®ÀàµÄÎÄÕÂô£¿ »òÕßÄÄλ¸øÌṩһ¸öÁ¬½ÓÊý¾Ý¿âµÄʾÀý´úÂë,¸Ðл..
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......