ÈçºÎÈëÃÅORACLEÊý¾Ý¿â¿ª·¢
³õѧORACLE£¬Ö®Ç°¿´¹ýµÄ¶¼ÊÇЩ¹ÜÀí·½ÃæµÄÊ飬¹Ù·½Îĵµ¿´¹ýCONCEPTS,ADMINISTRATOR'S GUIDE£¨ÕýÔÚ¿´£© ¿ÉºÃÏñ¸Õ±ÏÒµ¾Í¸ã¹ÜÀí²»Ì«ÏÖʵ£¬²îµÄ֪ʶҲ»¹Í¦¶à£¬ËùÒÔÏë´Ó¿ª·¢ÏÈ×öÆð ×î½ü¿´µ½Óмҹ«Ë¾ÔÚÕÐORACLEÓ¦ÓÃÊý¾Ý¿â¿ª·¢µÄ£¬ÒªÇóÉÏдµÄÊÇ ¡°ÊìϤORACLE ,PL/SQL,LINUX,SHELL¡± ÎÒÏÖÔÚ¿´Ò»±¾ÖÐÎÄÊé½Ð¡¶ORACLE DATABASE 10G PL/SQL¡· Çë´ó¼Ò°ïÃ¦ÍÆ¼öÏÂÓÐûÓÐʲôºÃµãµÄÈëÃÅÊý¾Ý¿â¿ª·¢·½ÃæµÄ½Ì²Ä ºÇºÇ ˵À´²ÑÀ¢ ÎÒÉõÖÁ»¹²»Ì«Á˽âÊý¾Ý¿â¿ª·¢µ½µ×ÊÇ¿ª·¢³ö¸öʲô¶«Î÷À´ ×îºÃÍÆ¼öµÄÊéÉÔ΢±¡Ò»µã ÒòΪ¹À¼ÆÔµ×ÍøÉ꿪ʼ 10Ô¾ͱÊÊÔÁË
ÎÒ¿´µÄµÚÒ»±¾ÊéÊǸǹúÇ¿µÄ <ÉîÈëdz³öORACLE> »¹²»´í.. ¶ÔOracle ½á¹¹Õâ¿é½²µÄ»¹±È½Ïϸ£¬¿ÉÒÔ×öÈëÃŵÄÊé¿´£¬Â¥Ö÷×ö¿ª·¢µÄ»°£¬»¹µÄ¿´¿´Ð´SQL·½ÃæµÄ°É.. ÎÒÖ÷Òª¸ãά»¤Õâ¿é.. ֪ʶÊÇÂýÂý»ýÀ۵ģ¬ÒÔºó¾Í¶®µÄÔ½À´Ô½¶àÁË. ÒýÓà ÏÖÔÚ¿´µÄÕâ±¾Êé¾Í²»´í.Ò»ÃÅÐÄ˼¿´ºÃËü¾Í¿ÉÒÔÁË£¬±ðÔÙÕÒÆäËûÊéÁË¡£ ¡°ÊìϤORACLE ,PL/SQL,LINUX,SHELL¡± ÕâÊÇÄļҹ«Ë¾°¡£¬¼¼ÊõÌ«·ûºÏÎÒÁË ºÇºÇ °¢Àï°Í°ÍÒýÓà ÎÒ¿´µÄµÚÒ»±¾ÊéÊǸǹúÇ¿µÄ <ÉîÈëdz³öORACLE> »¹²»´í.. ¶ÔOracle ½á¹¹Õâ¿é½²µÄ»¹±È½Ïϸ£¬¿ÉÒÔ×öÈëÃŵÄÊé¿´£¬Â¥Ö÷×ö¿ª·¢µÄ»°£¬»¹µÄ¿´¿´Ð´SQL·½ÃæµÄ°É.. ÎÒÖ÷Òª¸ãά»¤Õâ¿é.. ֪ʶÊÇÂýÂý»ýÀ۵ģ¬ÒÔºó¾Í¶®µÄÔ½À´Ô½¶àÁË. ¶Ô ÎÒÏÖÔÚ¾ÍÊÇÏë¶ÍÁ¶Ò»ÏÂ×Ô¼ºÐ´SQLÄÜÁ¦ ÓÐʲôºÃµÄ½¨ÒéÂð ÓеÄʱºòÔÚÂÛ̳Àï¿´µ½Ò»Ð©Ìû×ÓÀïµÄSQLÎÒ¿´¶¼¿´²»¶® Î
Ïà¹ØÎÊ´ð£º
<?php getenv("ORACLE_HOME"); $conn=ocilogon("test","test","test_db"); if($conn) echo success; &nb ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô? 2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8). ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ. ²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô? Äĸö»Ø¸öÌ ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôÔÒò,ÇëÖ¸½Ì.... лл' Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-39016: Operation not supported when job is in EXECUTING ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£ ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......