如何在Powershell ISE中使用sqlplus运行SQL文件

$oracleHome = "C:\oracle\client\product\12.2.0\client_1"  # 替换为你的Oracle客户端安装路径
$tnsName = "ORCL"  # 替换为你的数据库连接名
$sqlFile = "C:\path\to\your\sqlfile.sql"  # 替换为你的SQL文件路径

$env:ORACLE_HOME = $oracleHome
$env:PATH = "$oracleHome\bin;" + $env:PATH

$sqlplusCmd = "sqlplus"
$connectString = "/nolog"
$connectString += " @" + $sqlFile

Start-Process -FilePath $sqlplusCmd -ArgumentList $connectString -Wait