SQLを実行し結果をコンソール出力
PowerShell
[System.Reflection.Assembly]::LoadWithPartialName("System.Data") $cs = "Provider=MSDAORA;User ID=xxxxx;Password=yyyyy;Data Source=zzzzz" $oraCon = New-Object System.Data.OleDb.OleDbConnection($cs) $oraCmd = New-Object System.Data.OleDb.OleDbCommand $oraCon.Open() $oraCmd.Connection = $oraCon $oraCmd.CommandText = "SELECT * FROM wwwwww" $oraReader = $oraCmd.ExecuteReader() while ($oraReader.Read()) { for ($i = 0; $i -le $oraReader.FieldCount; $i++) { if ($oraReader[$i] -eq $null) {Write-Host "`t" -noNewLine} else {Write-Host $oraReader[$i].ToString() "`t" -noNewLine} } Write-Host } $oraCmd.Dispose() $oraCon.Close() $oraCon.Dispose()