SQL Script for read information from a csv file in FTP Server
来源:互联网 发布:剑雨江湖进阶数据仙器 编辑:程序博客网 时间:2024/06/01 17:38
DECLARE w_file_path VARCHAR2(4000) := 'XXIF_INPUT'; --all_directories.directory_name w_file_name VARCHAR2(4000) := 'lcytest001.csv'; --The file name w_file_exists BOOLEAN; w_file_length NUMBER(10) DEFAULT 0; w_file_type utl_file.file_type; w_line VARCHAR2(4000) DEFAULT NULL; w_rec_count NUMBER := 1; w_block_size BINARY_INTEGER; -- TYPE tbl_varchar2 IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER; rec_record tbl_varchar2;BEGIN -- fnd_global.apps_initialize(user_id => 1110, resp_id => 50683, resp_appl_id => 222); -- utl_file.fgetattr(w_file_path, w_file_name, w_file_exists, w_file_length, w_block_size); IF NOT w_file_exists THEN dbms_output.put_line('The File is not exist!'); END IF; -- IF w_file_length = 0 THEN dbms_output.put_line('The File is empty!'); END IF; -- w_file_type := utl_file.fopen(location => w_file_path, filename => w_file_name, open_mode => 'r', max_linesize => 32767); LOOP utl_file.get_line(w_file_type, w_line, 32767); dbms_output.put_line('Information is :' || w_line); rec_record(w_rec_count) := w_line; w_rec_count := w_rec_count + 1; END LOOP;EXCEPTION WHEN no_data_found THEN utl_file.fclose(w_file_type);END;
0 0
- SQL Script for read information from a csv file in FTP Server
- SQL Script for select data from ebs and make a csv file to FTP
- Download a file from a FTP Server
- How to read data from csv file in c#
- How to read data from a file in reverse order?
- How to read a frame from YUV file in OpenCV?
- Read a file from xml
- Read file from inside a JAR file
- Java CSV读--Read And Parse CSV File In Java
- read line from file with bash shell script
- a simple shell script for ftp
- IDL read table from a .txt file
- Read CSV From PHP
- How to Remove PDF/A Information from a file
- read csv file. TextFieldParser
- How to read and parse CSV file in Java
- Shell Script Utility To Read a File Line By Line
- How do I generate a SQL script from my diagram in MySQL Workbench?
- SAT阅读真题考什么?
- CocoaPods安装和使用教程
- 尽快报告坏消息
- Lombok — Java代码自动生成 开发利器 Eclipse for Mac
- UVa 11463 - Commandos
- SQL Script for read information from a csv file in FTP Server
- JAXB注解使用
- 中文分词的应用 新浪和庖丁两种方式对比
- HDU 3277 Marriage Match III(并查集+二分答案+最大流SAP)拆点,经典
- 如何做淘宝客推广淘宝客教程视频
- java操作redis
- 50条大牛C++编程开发学习建议
- RMAN-06026,RMAN-06100
- socket的发送和接收缓冲区