两个不同的查询做同样的工作，但一个工作，而不是

本文介绍了两个不同的查询做同样的工作，但一个工作，而不是的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在处理两个不同的查询做同样的事情，但运行两次PowerShell后一个查询失败。第一个查询：

I am working on two different query does same thing but one query fails after running powershell twice. First query:

'{0,-59}{1,20}' -f "DROP table $worktablename",(Get-Date -Format yyyyMMdd:hhmmss); try { INVOKE-SQLPLUS -MESSAGEONFAIL 'DROP WORK TABLE FAILED' -QUERY @" SET SERVEROUT ON; SET TERM ON; SET TIMING ON; SET SERVEROUTPUT on; WHENEVER SQLERROR EXIT SQL.SQLCODE; EXEC DROP TABLE $('amiuser1.$worktablename'); COMMIT; "@ @" try { $null = Execute-NonQuery-Oracle "DROP TABLE $('amiuser1.$worktablename')" } Catch { } Finally { }

但是每次运行以下查询都有效：

But running following query works everytime :

'{0,-59}{1,20}' -f "Create work table WRK_UCMU073_SU_EDIT_DETAIL",(Get-Date -Format yyyyMMdd:hhmmss); Invoke-SqlPlus -MessageOnFail 'Create work table WRK_UCMU073_SU_EDIT_DETAIL failed' -Query @" SET PAGES 60; SET LINES 170; SET ECHO ON; SET serveroutput on; WHENEVER sqlerror exit sql.sqlcode; EXEC drop_work_table('WRK_UCMU073_SU_EDIT_DETAIL'); create table amiuser1.WRK_UCMU073_SU_EDIT_DETAIL as select * from SU_EDIT_DETAIL where 1 = 0; grant select on amiuser1.WRK_UCMU073_SU_EDIT_DETAIL to misdev; commit; "@

推荐答案

worktablename，（Get-Date -Format yyyyMMdd：hhmmss）; try { INVOKE-SQLPLUS -MESSAGEONFAIL ' DROP WORK TABLE FAILED' -QUERY @ SET SERVEROUT ON; SET TERM ON; 设定时间; SET SERVEROUTPUT开; WHENEVER SQLERROR EXIT SQL.SQLCODE; EXEC DROP TABLE worktablename",(Get-Date -Format yyyyMMdd:hhmmss); try { INVOKE-SQLPLUS -MESSAGEONFAIL 'DROP WORK TABLE FAILED' -QUERY @" SET SERVEROUT ON; SET TERM ON; SET TIMING ON; SET SERVEROUTPUT on; WHENEVER SQLERROR EXIT SQL.SQLCODE; EXEC DROP TABLE

（'amiuser1。 ('amiuser1.

worktablename'）; COMMIT; @ @ try { worktablename'); COMMIT; "@ @" try {