Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle ±¾µØÎļþµÄд³öÎÊÌâ

SQL code:

declare
fhandle utl_file.file_type;
fp_buffer varchar2(4000);
begin
fhandle := utl_file.fopen ('DATA_SHIPPING','test.txt', 'R');--'DATA_SHIPPING'ÊDZ¾µØµÄÒ»¸ö·¾¶ ÆäֵΪ£º'/mnt/SShare/data/shipping'
utl_file.fclose(fhandle);
end;



ÉÏÃæ´úÂë¿ÉÒÔÕý³£ÔËÐС£
µ«ÊÇÒÔдµÄÐÎÊÆ´ò¿ª ¾Í²»ÐÐÁË

fhandle := utl_file.fopen ('DATA_SHIPPING','test.txt', 'W');

ÕâÑù¾Í»á±¨´íÁË£¡

ÓÐÄÄλ´óÏÀ Á˽âÊÇʲôԭÒò£¬¸æËßһϡ£Ð¡µÜÕâÀïл¹ýÁË¡£
¿ÉÄÜÊǶÔĿ¼ûÓÐдµÄȨÏÞ£¬ÓÃuser_tab_privs_recd±í¿´¿´

SQL code:
SELECT owner, table_Name, privilege from user_tab_privs_recd
WHERE table_name='DATA_SHIPPING';


¸Ðл  zcs_1 µÄ´ð¸´¡£
µ«ÊÇ£¬½á¹ûÈçÏ£º

1 SYS DATA_SHIPPING READ
2 SYS DATA_SHIPPING WRITE

»¹ÊDz»ÄÜ Ð´£¡

ÒýÓÃ
SQL codedeclare
    fhandle  utl_file.file_type;
  fp_buffervarchar2(4000);begin
    fhandle := utl_file.fopen ('DATA_SHIPPING','test.txt','R');--'DATA_SHIPPING'ÊDZ¾µØµÄÒ»¸ö·¾¶ ÆäֵΪ£º'/mnt/SShare/data/shipping'  utl_file.fclose(f


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

Çó½â MyEclipseÖÐÉèÖÃÁ¬½ÓOracle 10g³öÏÖµÄÎÊÌâ

ÈçÌâ¡£
¸ÕÔÚ×Ô¼ºµÄµçÄÔÀï°²×°ÀïOracle 10g
ÓÃMyEclipseÉèÖÃÁ¬½Ó£¬³öÏÖÈçÏ´íÎóÌáʾ£¬ÇëÎʸ÷λ¸ßÊÖÄÄÀï³öÁËÎÊÌ⣺¶àлָ½Ì£¡

Error while performing database login with the Oracle driver:
Io exc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ