首页
\
问答
\
Oracle 11g - 运行windows批处理文件在sqlplus中运行多个sql文件(Oracle 11g - run windows batch file to run multiple sql files in sqlplus)
Oracle 11g - 运行windows批处理文件在sqlplus中运行多个sql文件(Oracle 11g - run windows batch file to run multiple sql files in sqlplus)
我想用一个批处理文件在一个序列中执行多个sql .. IE:sql2脚本调用一个由sql1脚本创建的表..等..
这里是我到目前为止的批处理代码..它可以运行一个单独的sql文件,但我需要它运行第一个,然后再下一个..在此先感谢。
@ECHO OFF echo. echo. SET /P uname=Username: echo. echo. SET /P pass=Password: echo. echo. SET /P mydatabase=Database: echo. echo. set oracle_sid=ins sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table1_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table2_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table3_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table4_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table5_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table6_.sql \n sqlplus exit pause
I would like to use a single batch file to execute multiple sql in a sequence.. IE: sql2 script calls a table created by sql1 script.. etc..
here is the batch code I have so far.. it works to run a single sql file but I need it to run the first one and then then next.. thanks in advance.
@ECHO OFF echo. echo. SET /P uname=Username: echo. echo. SET /P pass=Password: echo. echo. SET /P mydatabase=Database: echo. echo. set oracle_sid=ins sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table1_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table2_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table3_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table4_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table5_.sql \n sqlplus -s %uname%/%pass%@%mydatabase% @J:/A/scripts/_TABLES/Table6_.sql \n sqlplus exit pause
原文:https://stackoverflow.com/questions/12679626
更新时间:2023-10-03 06:10
最满意答案
更改您的PHP,以便将ID放入
<select>
的名称:<select name="mypurpose[<?php echo $id; ?>]">
然后在PHP中,您可以:
foreach ($_POST['selector'] AS $selected) { $purpose = $_POST['mypurpose'][$selected]; ... }
Change your PHP so that you put the ID into the name of the
<select>
:<select name="mypurpose[<?php echo $id; ?>]">
Then in your PHP, you can do:
foreach ($_POST['selector'] AS $selected) { $purpose = $_POST['mypurpose'][$selected]; ... }
相关问答
更多-
好的 - 我想我已经弄明白了。 你是对的 - 主要问题在于你的isset和isempty电话。 我在您的文件上创建了一些变体,这显示了正在发生的事情。 注意 - 因为我没有你的某些“其他”功能,所以我只显示你的功能外部出了什么问题。 第1部分:验证功能 在下面的代码中,我在输入表单中添加了两个JavaScript函数; 这些松散地基于您在谷歌“JavaScript验证复选框”时可以找到的脚本。 oneBoxSet(groupName)函数将查看所有文档元素; 找到类型为checkBox的那些,查看是否检查了 ...
-
未经测试但它应该像这样工作: $('#button-cart').hover(function () { var parent, sum = 0; $('table.table-bordered input[type="checkbox"]:checked').each(function() { // get current row parent = $(this).closest('tr'); // in row find input and ...
-
你不必要地循环。 尝试这个: $day_name): ?>$cb1 = ($_POST['cb1'] == 'YES')?'YES':'NO'; 如果未单击该复选框,则该值将为null,即不会设置变量$ _POST ['cb1']。 $cb1 = ($_POST['cb1'] == 'YES')?'YES':'NO'; If the checkbox is not ...
在php中选中复选框时,如何获得[2023-08-18]
更改您的PHP,以便将ID放入的名称: 然后在PHP中,您可以: foreach ($_POST['selector'] AS $selected) { $purpose = $_POST['mypurpose'][$selected]; ... } Change your PHP so that you put the ID into the name of the 选中所有的复选框,并将复选框的值设置为'on'jquery(select all checkbox and have the value of checked checkbox to 'on' jquery)[2023-08-02]
问题是if ($("input[name='resolution[]']:checked")) { , $("input[name='resolution[]']:checked")将返回一个jQuery对象,所有选中的复选框,名称resolution[] 你需要 $('#res').click(function () { var resolutiontemp = {}; var resolution = []; $("input[name='resolution[]']").eac ...PHP / AJAX复选框值(PHP / AJAX checkbox values)[2023-06-25]
您可以发送已检查项目的json: