bash - 如何通过 SQLPlus 将 SQL 脚本附加到 bash 循环?
问题描述
我想通过sqlplus并基于路径中的文件名(path/to/files )从所有数据( Table_with_DB(它在程序 sqldeveloper 中))中清除表,使用 SQLPlus 完成表(Table_with_DB)路径中的文件名.
我创建了 2 个单独的 SQL 文件(clear.sql;register.sql)
和 1 与 bash ( bashloop.sh )
清除.sql
BEGIN
package.clear('Table_with_DB');
END;
注册.sql
BEGIN
package.register('folderName' , '&1);
END;
bashloop.sh
for i in path/to/files;
do
sqlplus -s userid/password@ @clear.sql
sqlplus -s userid/password@ @register.sql
done
我希望查询清除Table_with_DB并使用SQLPlus将文件名从path/to/files 传输到Table_with_DB
但实际上它不起作用:(
解决方案
循环中的示例 sqlplus。
#!/bin/bash
username=system
password=passwordsystem
tns_alias=esmd
for i in /opt/oracle/example1/test*/file*.txt;
do
$ORACLE_HOME/bin/sqlplus $username/$password@$tns_alias <<EOF
SET SERVEROUTPUT ON SIZE 2000
BEGIN
dbms_output.put_line('$i');
END;
/
EOF
done;
示例输出
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL> SQL> 2 3 4 /opt/oracle/example1/test2/file2.txt
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 22 13:59:24 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL> SQL> 2 3 4 /opt/oracle/example1/test3/file3.txt
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 22 13:59:24 2019
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL> SQL> 2 3 4 /opt/oracle/example1/test4/file4.txt
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
oracle@esmd:~/example1>
推荐阅读
- if-statement - 传单中基于颜色折线的geojson属性
- jspdf - jspdf Autotable CellHeight 或 RowHeight Auto
- graphql - 不能为不可为空的字段 Subscription.counter 返回 null
- java - React & Java:如何让 accountId(事务表中的外键)填充到数据库中?
- lua - 如何在 LUA 中使用非整数而不使用浮点数
- tensorflow - Colab:将运行时更改为本地后无法运行任何单元格
- javascript - 无法使用 Laravel Mix 加载 popper.js
- html - 如何在 golang 模板中使用对象数组?
- c# - XamarinForms 代码已过时的问题
- html - 如果文件关联设置为 django-html,则 Intellisense for html 不起作用