两个不同的查询做同样的工作，但一个工作，而不是 [英] two difference query does same job but one work and other not

问题描述

我正在处理两个不同的查询做同样的事情，但运行两次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 {

这篇关于两个不同的查询做同样的工作，但一个工作，而不是的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！