当前位置:
Oracle读写文件bfilename的实例
时间:2025-11-05 03:12:20 出处:域名阅读(143)

复制SQL> create or replace directory UTL_FILE_DIR as /opt/oracle/utl_file; Directory created.SQL> declare fhandle utl_file.file_type; begin fhandle := utl_file.fopen(UTL_FILE_DIR,读写 example.txt, w); utl_file.put_line(fhandle , eygle test write one); utl_file.put_line(fhandle , eygle test write two); utl_file.fclose(fhandle); end; / PL/SQL procedure successfully completed. SQL> ! [oracle@jumper 9.2.0]$ more /opt/oracle/utl_file/example.txt eygle test write one eygle test write two [oracle@jumper 9.2.0]$ 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.
分享到:
温馨提示:以上内容和图片整理于网络,仅供参考,希望对您有帮助!如有侵权行为请联系删除!