excel - 用于将数据从 DB 提取到 Excel 的 Shell 脚本

Question

我已经编写了 shell 脚本来将数据库中的数据提取到 Excel 文件中，但它没有按预期工作。任何人都可以帮忙。

enter code here

#!/bin/ksh
sqlplus -s /nolog << EOF 
CONNECT test/test@IP
alter session set nls_date_format= 'DD-MON-YYYY';
SELECT DISTINCT * FROM   (SELECT G2.USR_ID "User ID",G2.USR_NAME "User Name" ,
    G3.GFCT_NAME "Belong to Function", G2.USR_EMAIL "E-mail",G2.USR_SSOID "SSO ID" , 
    DECODE (G2.USR_INACTIVE+G2.NCR_INACTIVE,1,'Inactif',2,'Inactif',NULL,NULL) "NCR Inactif" 
  FROM GLOBAL_FUNCTION_ACTOR G1,GLOBAL_FUNCTION G3,USR_APPLI G2
  WHERE G1.USR_ID = G2.USR_ID AND G1.GFAR_ID  = '2' AND G3.GFCT_ID  =G1.GFCT_ID
  ) sub1
ORDER BY 3 ASC 
end;
/
EOF

标签： excelshellsqlplus