UTL_FILE [英] utl_file
问题描述
我创建了一个文件
c; /temp/test.txt
000 23102007
001 21102007 [23102007 GB11223344
001 20102007 22102007 GB11223345
001 19102007 22102007 GB11223346
999 3
突出显示的文本是开始日期和结束日期
假设我想通过读取数据来编写select语句来自test.txt ..在我的where子句中,我必须将输入参数作为开始日期和结束日期。
cud u请告诉我如何操作。
Thnaks
I have created one file
c;/temp/test.txt
000 23102007
001 21102007 [23102007 GB11223344
001 20102007 22102007 GB11223345
001 19102007 22102007 GB11223346
999 3
The highlighted text are started date and end date
Suppose I wanted to write a select statement by reading the data from the test.txt .. In my where clause I have to give input parameter as start date and end date .
cud u please tell me how to to it .
Thnaks
推荐答案
我创建了一个文件
c; /temp/test.txt
000 23102007
001 21102007 [23102007 GB11223344
001 20102007 22102007 GB11223345
001 19102007 22102007 GB11223346
999 3
突出显示的文本以da开头te和结束日期
假设我想通过读取test.txt中的数据来编写select语句..在我的where子句中,我必须将输入参数作为开始日期和结束约会。
cud u请告诉我怎么做。
Thnaks
I have created one file
c;/temp/test.txt
000 23102007
001 21102007 [23102007 GB11223344
001 20102007 22102007 GB11223345
001 19102007 22102007 GB11223346
999 3
The highlighted text are started date and end date
Suppose I wanted to write a select statement by reading the data from the test.txt .. In my where clause I have to give input parameter as start date and end date .
cud u please tell me how to to it .
Thnaks
请发布你试图实现的内容吗?
Kindly POST what you have tried to achieve this?
如果你想使用输入参数来获取数据,那么
1将数据从平面文件传输到oracle数据库表
2.从表中,使用select语句通过传递输入参数获取数据
If you want to use input parameters for fetching the data, then
1. transfer the data from flat file in to oracle database table
2. from the table, make use of select statement to fetch the data by passing input parameters
我创建了以下块
I have created following block
这篇关于UTL_FILE的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!