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»ÄÜ Ð´£¡
Ïà¹ØÎÊ´ð£º
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
±í¼Ç¼
======================================
name date score
Fei Zhang 1 100
Fei Zhang  ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......