| $jsondata | ConvertTo-Json | % { [System.Text.RegularExpressions.Regex]::Unescape($_) } | Out-File "File.json" -Force |
| ## Will list the content present in Both the files | |
| $file1 = import-csv -Path "C:\ps\output\obj1.csv" | |
| $file2 = import-csv -Path "C:\ps\output\obj2.csv" | |
| [linq.enumerable]::intersect( [object[]]($file1.name), [object[]]($file2.name) ) | Export-Csv -NoTypeInformation -Path "C:\ps\result\result.csv" | |
| ## will list the content present either in one of the files but not in both | |
| $file1 = import-csv -Path "C:\ps\output\obj1.csv" | |
| $file2 = import-csv -Path "C:\ps\output\obj2.csv" | |
| $res = [Collections.Generic.HashSet[String]]( [string[]]($file1.name) ) | |
| $res.SymmetricExceptWith( [string[]]($file2.name) ) | |
| $res | Export-Csv -NoTypeInformation -Path "C:\ps\result\result.csv" | |
| ## For union operation, you can try like this | |
| [system.linq.enumerable]::union([object[]](1,2,3),[object[]](2,3,4)) |
C:\, which creates C:\ODP.NET_Managed_ODAC12cR4.cmd as administrator, navigate to C:\ODP.NET_Managed_ODAC12cR4, and run:install_odpm.bat C:\oracle\instantclient_10_2 both$username = Read-Host -Prompt "Enter database username"
$password = Read-Host -Prompt "Enter database password"
$datasource = Read-Host -Prompt "Enter database TNS name"
$query = "SELECT first_name, last_name FROM users WHERE last_name = 'Lastname' ORDER BY last_name"
$connectionString = 'User Id=' + $username + ';Password=' + $password + ';Data Source=' + $datasource
$connection = New-Object Oracle.ManagedDataAccess.Client.OracleConnection($connectionString)
$connection.open()
$command=$connection.CreateCommand()
$command.CommandText=$query
$reader=$command.ExecuteReader()
while ($reader.Read()) {
$reader.GetString(1) + ', ' + $reader.GetString(0)
}
$connection.Close()Expected Output:
Input from remote and Invoke a GUI script
cmd.exe /C "pushd \\remoteserver\FolderName && Filename && popd"