Âé·³´ó¼ÒÁË
ÎÒÕâ¸öÈËÓ¢Óï²»ºÃ£¬¹Ù·½¸øµÄOracleµÄÏÂÔØµØÖ·¶¼ÊÇÓ¢ÎÄµÄ ÎÒ¿´²»¶®£¬ÎÒÏÖÔڵIJÙ×÷ϵͳÊÇ£ºMircosoft Windows XP Professional °æ±¾ 2002 Service Pack 3
Çë´ó¼Ò¸ø¸öÕâ¸öϵͳÄÜÓõÄOracleÊý¾Ý¿âÏÂÔØµØÖ·£¬±ð¸øÓкöàÏÂÔØÏîµÄ ÎÒ˵ÁË ÎÒÓ¢ÎÄ¿´²»¶®µÄ ллÄãÃÇÁË
¸ø¸öÄܵã»÷ÏÂÔØ Ö±½Óµ¯³öѸÀ×ÏÂÔØ¿òµÄ
......
ÔÚwindows server 2008 X64ϵͳÖа²×°ÁËoracle 11g X64£¬°²×°ºó£¬ÓÃsql developer¿ÉÒÔÁ¬½ÓÉÏÊý¾Ý¿â·þÎñÆ÷£¬Ò²¿ÉÒÔͨ¹ýsql plus½øÐвÙ×÷£¬µ«ÊÇ¿´µ½°²×°ºó£¬Ã»ÓÐisql plus¡£È»ºóÔÙ°²×°pl/sql developer 7.1.5£¬È»ºóÁ¬½ÓÊý¾Ý¿â·þÎñÆ÷£¬ÔòÁ¬½Óʧ°Ü£¬Ìáʾ¾ßÌåÄÚÈݲ»¼ÇµÃÁË£¬ºÃÏóÊÇÖ¸¼àÌýÎÊÌâʲôµÄ£¬ÇëÎÊÓÐûÓÐÄÄλÓÃpl/sql deve ......
oracleÊý¾Ý¿âÖУ¬ÓÃϵͳ¹ÜÀíÔ±µÇ½£¬Ôõô·ÃÎÊÆäËüÓû§´´½¨µÄ±í
select * from other_user.other_table;
ÄÇÔõô²é¿´ÆäËûÓû§´´½¨µÄËùÓбíµÄÃû³ÆÄØ
select table_name from user_tables where user='CARTOON';//Ö¸¶¨Óû§µÄ±í
select table_name from all_tables; //ËùÓÐÓû§ ......
ÎÒÏÖÔÚÓÐÁ½ÖÖÊý¾Ý¿â£¬Ò»¸öΪoracle 11g£¬°æ±¾Îª£º11.1.0.6.0 - 64bit£¬°²×°ÔÚHP-IA64µÄ·þÎñÆ÷ÉÏ£¬Ò»¸öΪmysql 5.1£¬°²×°ÔÚͬһ̨·þÎñÆ÷ÖС£
ÏÖÔÚҪʵÏÖoracleµÄÊý¾Ý¿âÄܹ»²éѯmysqlÊý¾Ý¿âµÄ±í£¬ÏëҪͨ¹ýoracleµÄÒì¹¹¹¦ÄÜÀ´ÊµÏÖ£¬µ«ÓÉÓÚСµÜ¶ÔÊý¾Ý¿âÁ˽ⲻÉ»¹Çë¸÷λ°ïæ¡£
ÒÔÏÂΪÎҵĸ ......
aspÔ¤ÑÔ£¬accessÊý¾Ý¿â£¬Ôõôת»»³ÉoracleÊý¾Ý¿âµÄ£¬¾ßÌåÒªÔõô²Ù×÷£¬ÎÒ²»ÊÇoracle·½ÃæµÄ£¬ËùÒÔÇó½Ì¶®µÄÈË!лл£¡
½¨±í,µ¼ÈëÊý¾Ý!²»ÊÇÒ»Ñù,¾ÍÊÇÀàÐ͵Äת»»!
»¹ÓÐÎÊÌâ¾ÍÊÇaspºÍoracleÁ¬½ÓµÄÎÊÌ⣬Õâ¸öºÃÏñÓõIJ»¶à
Òì¹¹Êý¾Ýµ¼ÈëÖ»ÓÐ
SQLLDR,¸öÈ˾õµÃÄǸö¸ñʽ¹æÔòдÆðÀ´»áºÜÀÛµÄ
¶Ôoracle²»ÊǺÜÁ˽⣬ֻ֪ ......
ÈçºÎ½«oracleÖÐblob µ¼Èëµ½accessÖУ¿
accessÖÐûÓÐblob×ֶΣ¬¸ÃÓÃʲôÀàÐÍ£¿
ÎÒoracleÖеÄblob×Ö¶ÎÊÇͼƬ
ÎÒÏÖÔÚÊÇÓÃpowerbuilerÓà selectblob È¡³ö£¬ÔÙupdateblobµ½accessÖУ¬¶¼Ã»Óгö´í¡£µ«ÊÇ´ÓaccessÖÐÈ¡³öÀ´µÄÎÞ·¨ÏÔʾͼƬ£¿
char(255)
ÄÇÔõôµ¼È룬ÓÃʲô·½·¨ÄØ£¿ÎÒÏÖÔÚÓõİ취ÎÞ·¨ÊµÏÖÎÒÒªµÄ½á¹û£¡
......