如何仅从powershell启动的sqlplus脚本中仅打印dbms_out的输出

发布于 2025-02-05 21:15:02 字数 566 浏览 2 评论 0原文

myScript.sql：

set serveroutput on
set feedback off
set heading off
set echo off


DECLARE
    CURSOR c1 IS
        select 2 from dual
BEGIN
    FOR i IN c1
    LOOP
        DBMS_OUTPUT.put_line (i.object_text );
    END LOOP;
END;
/
exit;

我以此为脚本：

sqlplus  user/pass@database  @Dpath\myscript.sql  -S | Out-String | echo

SQL*Plus版本.......总是在开始时打印出来。我不要。
我的查询线打印。没关系。
断开连接....从Oracle数据库中总是打印出来。我不希望它

这个代码只是一个可生殖的例子。我知道，对于特定情况，还有其他方法可以做到这一点。但是我想要的是只打印DBMS_OUT

原文

myscript.sql:

set serveroutput on
set feedback off
set heading off
set echo off


DECLARE
    CURSOR c1 IS
        select 2 from dual
BEGIN
    FOR i IN c1
    LOOP
        DBMS_OUTPUT.put_line (i.object_text );
    END LOOP;
END;
/
exit;

I call my script with that:

sqlplus  user/pass@database  @Dpath\myscript.sql  -S | Out-String | echo

SQL*Plus Version..........is always printed in the beginning. I don't want it.
the lines of my query are printed. that is OK.
Disconnected .... from Oracle Database is always printeed in the end. I don't want it

This code is just a reproductible example.I know that for the particular case, there is other way to do that. But what I want is to print just the dbms_out

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

時窥 2025-02-12 21:15:03

您只需使用spool来创建一个单独的文件，您将在其中完全控制所打印内容。您还可以使用选项的组合设置反馈，设置头和设置验证以删除接收到的行数，列名称等，使您的文件看起来更像是实际报告，而不是重定向的输出。

回复收藏 0 原文

柠檬 2025-02-12 21:15:03

    set serveroutput on
    set feedback off
    set heading off
    set echo off

    DECLARE
        CURSOR c1 IS
            select 2 as object_text  from dual;
    BEGIN
        FOR i IN c1
        LOOP
            DBMS_OUTPUT.put_line (i.object_text );
        END LOOP;
    END;
    /
    EXIT;


    PS C:\otr> sqlplus -s user/password@dev19  @c:\otr\file1.sql  -S | Out-String | echo
    2

    set serveroutput on
    set feedback off
    set heading off
    set echo off

    DECLARE
        CURSOR c1 IS
            select 2 as object_text  from dual;
    BEGIN
        FOR i IN c1
        LOOP
            DBMS_OUTPUT.put_line (i.object_text );
        END LOOP;
    END;
    /
    EXIT;


    PS C:\otr> sqlplus -s user/password@dev19  @c:\otr\file1.sql  -S | Out-String | echo
    2

回复收藏 0 原文

~没有更多了~