<#.Synopsis Run a script in SQLCL.DESCRIPTION Running a script with SQLCL Output is being saved in a variable.PARAMETERsqlscript.PARAMETERowner.PARAMETERpassword.PARAMETERdatabase.EXAMPLE run-sql -sqlscript “c:scriptssqlscript.sql” -owner “<dbuser>” -password “<password>” -database “<database>”.NOTES #>functionrun-sql{[CmdletBinding()][Alias()][OutputType([int])]param([Parameter(Mandatory=$true,ValueFromPipelineByPropertyName=$true)]$sqlscript,$owner,$password,$database)Begin{##}Process{$connect_string=$owner+“/”+“$password”+“@”+$databaseif($owner-eq‘sys’){Start-Process-FilePath $sqlcl_exe-ArgumentList “$owner/`”$password`”@$database as sysdba”,“@$sqlscript”-Wait}else{$myarg=“$owner/`”$password`”@$database @$sqlscript”start-Process-FilePath $sqlcl_exe-ArgumentList $myarg-Wait}}End{}}