主页 / dba / 问题 / 325164
Accepted
Nir
Asked: 2023-03-25 17:16:57 +0800 CST

如何使 login.sql 输出静音

  • 772
[nir@dba etl]$ cat login.sql
col TAB# new_value TAB NOPRINT
select chr(9) TAB# from dual;
set markup csv on delimiter "&TAB" quote off
set heading off termout off echo off feedback off verify off numformat 99999999999.9999999999999 null '\N'
[nir@dba etl]$ cat a.sh
#!/bin/bash

export ORACLE_PATH="/home/nir/etl"

echo "select * from dms_u.test_etl_source;" | sqlplus -s ${USER}/${PASS}@${TNS}

[nir@dba etl]$ ./a.sh




aa  \N  aa
\N  aa  aa
aa  aa  \N
\N  \N  aa
\N  aa  \N
aa  \N  \N
\N  \N  \N
aa  aa  aa

我正在使用 将输出login.sql设为sqlplustsv。我想要的是在没有任何输出的情况下运行login.sql。如果我将其放入glogin.sql会-s起作用。但我需要 tsv 登录仅在特定情况下发生（因此ORACLE_PATH）。

所以我想a.sh返回：

[nir@dba etl]$ ./a.sh
aa  \N  aa
\N  aa  aa
aa  aa  \N
\N  \N  aa
\N  aa  \N
aa  \N  \N
\N  \N  \N
aa  aa  aa
oracle

1 个回答

  1. Best Answer

    更改login.sql自：

    col TAB# new_value TAB NOPRINT
select chr(9) TAB# from dual;
set markup csv on delimiter "&TAB" quote off
set heading off termout off echo off feedback off verify off numformat 99999999999.9999999999999 null '\N'

    到：

    set heading off termout off echo off feedback off verify off numformat 99999999999.9999999999999 null '\N'
col TAB# new_value TAB NOPRINT
select chr(9) TAB# from dual;
set markup csv on delimiter "&TAB" quote off
    • 0

相关问题