Connessione a un DB Oracle tramite PowerShell

PowerShellCopia

$connectionString = "Data Source=nomeServerOracle;Persist Security Info=True;User ID=userNamet;Password=userPassword;Unicode=True"

$queryString = @"
SELECT COGNOME || + ' ' + || NOME AS "CognomeNome", datanas AS 'DataNascita"
FROM schema.TABANA
order by 1  
"@

#----------------------------------

[void][System.Reflection.Assembly]::LoadWithPartialName("System.Data.OracleClient")

$connection = New-Object System.Data.OracleClient.OracleConnection($connectionString)
$command = new-Object System.Data.OracleClient.OracleCommand($queryString, $connection)
$connection.Open()

$reader = $command.ExecuteReader()
$counter = $Reader.FieldCount
#ciclo su tutti i record
while ($reader.Read()) {
	for ($i = 0; $i -lt $counter ; $i++) {
		#aggiungo un hash table composta da nomeCampo e valoreCampo
		@{ $reader.GetName($i) = $reader.GetValue($i); }
	}
}
$connection.Close()