Use powershell to connect to the oracle database (value, update)

In our work, we often need to use powershell to connect to Oracle databases.

But the code found in Baidu is very old, and it also requires oracle database to connect to the client. After searching for it, I found that Oracle has already released the official link library to. Net, which is efficient and simple.

Link Library address:

Https://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html

I wrote a little demo:

Official documents:

Https://docs.oracle.com/cd/E11882_01/win.112/e23174/client.htm#ODPNT0008

Use case:

$AssemblyFile = "Oracle.ManagedDataAccess.dll" [Reflection.Assembly]:: LoadFile ($AssemblyFile) $username = "xx" $password = "xx" $datasource = "192.168.xx.xx/dbname" $sql = "SELECT * from xxdb" $connectionnectionString = 'User Id=' + $username +'; Password=' + $password +' Data Source=' + $datasource $connectionnection = New-Object Oracle.ManagedDataAccess.Client.OracleConnection ($connectionnectionString) $connectionnection.open () $command=$connection.CreateCommand () $command.CommandText=$sql $da = New-Object Oracle.ManagedDataAccess.Client.OracleDataAdapter ($command) $builder=New-Object Oracle.ManagedDataAccess.Client.OracleCommandBuilder ($da) # to update the database $ds = New-Object system.Data.DataSet [void] $da.fill ($ds, "xxdb") foreach ($row in $ds.Tables ["xxdb"]) {$row ["xxFLAG"] = "1" $da.Update ($ds) "xxdb") # Update database} $connection.close ()