Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

OracleÈçºÎʹÓô°¿Úº¯ÊýʵÏÖÕâÑùµÄ²éѯ

±í¼Ç¼
======================================
name        date        score
Fei Zhang  1          100
Fei Zhang  ......

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

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

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

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

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

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

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ