Power Shell script to automate need to install modules
Load required assemblies Add-Type -AssemblyName System.Windows.Forms Add-Type -AssemblyName System.Drawing function Show-MessageBox { param ( [string]$message, [string]$title ) [System.Windows.Forms.MessageBox]::Show($message, $title) } function Run-Queries { param ( [string]$selectedDate ) $queries = @( “SELECT * FROM your_table WHERE date_column = TO_DATE(‘$selectedDate’, ‘YYYY-MM-DD’)” ) * 10 $connectionString = “User Id=username;Password=password;Data Source=hostname/service_name” try { $connection = New-Object Oracle.ManagedDataAccess.Client.OracleConnection($connectionString) $connection.Open() $excel […]