Aug 01, 2012 · Let’s get the data! #Getting Data from Oracle Database Write-Host Write-Host -ForegroundColor White " Getting Data from Oracle database" $Oracle_data=$command.ExecuteReader() Start-Sleep -Seconds 2 if ($Oracle_data.read()) { Write-Host -ForegroundColor Green " Connection Success" Write-Host Write-Host -ForegroundColor White " Importing Oracle data to MOSS-List (Nyitott Incidensek)" } else { Write-Host -ForegroundColor Red " Connection Failed" } # After successfuly getting the data the ...
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g. (15 Replies)