#Oracle Strings
[Reflection.Assembly]::LoadFile("C:\oracle\product\10.2.0\client_1\odp.net\bin\2.x\Oracle.DataAccess.dll") #Obviously this path needs to be correct
$constr = "User Id=<>;Password=<>;Data Source=<>"
$conn = New-Object Oracle.DataAccess.Client.OracleConnection($constr)
$conn.Open()
$sSQL = "<Query>"
$command = New-Object Oracle.DataAccess.Client.OracleCommand($sSQL,$conn)
#....
$reader=$command.ExecuteReader()
for ($a=0;$a -lt $reader.FieldCount;$a++){}
While ($reader.read()) {
$str1=$reader.Getstring(0) #This is the first column value. You can assign others to Getstring(1)
$Var1 = <Do something with> $str1
}