PowerShell Oracle Sample

Oracle Sample

[void][reflection.assembly]::LoadWithPartialName("System.Data.OracleClient")

$ConnectionString = "Data Source=/******/;User ID=/*****/;Password=/*****/;Integrated Security=false;"

$OraConn = New-Object System.Data.OracleClient.OracleConnection($ConnectionString)

$dtSet = New-Object System.Data.DataSet
$strSQL = "SELECT * FROM EMP"

#Make Data Adapter
$oraDA = New-Object System.Data.OracleClient.OracleDataAdapter($strSQL, $OraConn)

##########################
#Data Get
[void]$oraDA.Fill($dtSet)

$dtSet.Tables[0] | Format-Table

#Make Command Builder
$OraCB = New-Object System.Data.OracleClient.OracleCommandBuilder($oraDA)

###########################
#Make New Record
$dtRow = $dtSet.Tables[0].NewRow()

$dtRow["ID"] = "001"
$dtRow["NAME"] = "krote"

$dtSet.Tables[0].Rows.Add($dtRow)

[void]$oraDA.Update($dtSet)

########################
#Delete Data
$dtRows= $dtSet.Tables[0].Select("ID=001")

foreach($dtRow in $dtRows)
{
    $dtRow.Delete()
}

$dtSet.Update($dtSet)