PLSQL UTL_FILE input from file
来源:互联网 发布:数据库的数据模型包含 编辑:程序博客网 时间:2024/06/15 11:04
SET serveroutput ONDECLARE fh utl_file.file_type; v_line VARCHAR2(32767);BEGIN fh := utl_file.fopen('DATA_PUMP_DIR','test.txt','R'); LOOP utl_file.get_line(fh,v_line); dbms_output.put_line(v_line); END LOOP;EXCEPTIONWHEN no_data_found THEN utl_file.fclose(fh);END;/
/**TL_FILE.GET_LINEが、ファイルの終端を超えてデータを読み込もうとすると、エラーとなるからです。PL/SQLではエラーが発生すると、例外処理部(EXCEPTION)に飛びます。
hellohow are you
0 0
- PLSQL UTL_FILE input from file
- PLSQL UTL_FILE output file
- SPICE <Restart> - Read Record from Input File
- Could not read input channel file descriptors from parcel
- Could not read input channel file descriptors from parcel.
- jQuery: Get filename from input [type='file']
- 解决Could not read input channel file descriptors from parcel
- RunTimeException-Could not read input channel file descriptors from parcel
- Could not read input channel file descriptors from parcel
- Error reading from file descriptor 13: Input/output error
- UTL_FILE
- utl_file
- utl_file
- UTL_FILE
- 用PLSQL中的UTL_FILE包来读写文件
- input file
- input file
- input file
- angular.bindbind 用法
- 鼠标点击不同位置触发的事件
- 使用Logback日志保存到相对路径记录
- javamail 邮箱
- 弹窗窗口在浏览器上面居中
- PLSQL UTL_FILE input from file
- Struts2——基于StrutsTypeConverter的类型转换
- spring 注解
- 每天一个Linux命令(1):ls命令
- 2016全球手游市场406亿美元 VR/AR功不可没
- 205. Isomorphic Strings
- JAVA中堆和栈的区别
- Codeforces 474D Flowers 线性DP
- WireShark如何抓取本地localhost的包