使用Parameter将GPILE CSV文件导入到Powershell中的oracle表中 [英] IMPORT CSV FILE into oracle table in Powershell with Parameter
问题描述
我正在尝试使用ParametersSo将csv数据导入到oracle表中我已经完成了以下但是如果它在那里我需要一些击球器:
我的解决方案:
'{0,-59} {1,20}' - f创建工作表WRK_UCMU074_SU_EDIT_DETAIL,(Get-Date -Format yyyyMMdd:hhmmss);
调用-SqlPlus -MessageOnFail'创建工作表WRK_UCMU074_SU_EDIT_DETAIL失败'-Query @
SET PAGES 60;
设置线路170;
SET ECHO ON ;
SET serveroutput on;
WHENEVER sqlerror exit sql.sqlcode;
EXEC drop_work_table('WRK_UCMU074_SU_EDIT_DETAIL');
创建表WRK_UCMU074_SU_EDIT_DETAIL为
从SU_EDIT_DETAIL中选择IMAGE_RECNBR,CODE_BEGIN,CODE_END,其中1 = 0;
授予amiuser1.WRK_UCMU074_SU_EDIT_DETAIL选择misdev;
commit;
@
*********** ************************************************** ******************
'{0,-60} {1,20}'-f将TEEN PREGNANCY ICD10 CODES插入WRK_UCMU074_SU_EDIT_DETAIL,(Get-Date -Format yyyyMMdd:hhmmss);
foreach($文件在目录$($ UCMCSVLoadLocation3) - recurse -filter* .csv)
{
$ fileContents = Import-Csv - Path $ file.fullName
foreach($ file in $ fileContents)
{
$ null = Execute-NonQuery-Oracle -sql @
插入WRK_UCMU074_SU_EDIT_DETAIL(IMAGE_RECNBR,CODE_BEGIN,CODE_END)
值
(0,'$($ line。CODE_BEGIN)', '$($ line。CODE_END)')
@
}
}
I am trying to import csv data to oracle table with ParametersSo far I have done following but I need something batter if it is out there:
My solution:
'{0,-59}{1,20}' -f "Create work table WRK_UCMU074_SU_EDIT_DETAIL",(Get-Date -Format yyyyMMdd:hhmmss);
Invoke-SqlPlus -MessageOnFail 'Create work table WRK_UCMU074_SU_EDIT_DETAIL failed' -Query @"
SET PAGES 60;
SET LINES 170;
SET ECHO ON;
SET serveroutput on;
WHENEVER sqlerror exit sql.sqlcode;
EXEC drop_work_table('WRK_UCMU074_SU_EDIT_DETAIL');
create table WRK_UCMU074_SU_EDIT_DETAIL as
select IMAGE_RECNBR,CODE_BEGIN,CODE_END from SU_EDIT_DETAIL where 1 = 0;
grant select on amiuser1.WRK_UCMU074_SU_EDIT_DETAIL to misdev;
commit;
"@
"*******************************************************************************"
'{0,-60}{1,20}' -f "Insert TEEN PREGNANCY ICD10 CODES into the WRK_UCMU074_SU_EDIT_DETAIL",(Get-Date -Format yyyyMMdd:hhmmss);
foreach ($file in dir "$($UCMCSVLoadLocation3)" -recurse -filter "*.csv")
{
$fileContents = Import-Csv -Path $file.fullName
foreach ($line in $fileContents)
{
$null = Execute-NonQuery-Oracle -sql @"
insert into WRK_UCMU074_SU_EDIT_DETAIL(IMAGE_RECNBR,CODE_BEGIN,CODE_END)
Values
(0,'$($line."CODE_BEGIN")','$($line."CODE_END")')
"@
}
}
推荐答案
文件在目录
(
UCMCSVLoadLocation3)-recurse -filter * .csv)
{
UCMCSVLoadLocation3)" -recurse -filter "*.csv")
{
这篇关于使用Parameter将GPILE CSV文件导入到Powershell中的oracle表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!