Shulou(Shulou.com)06/03 Report--

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 ()

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.