对于上面的问题，解决方案是创建如下的script.sql：
对于上面的问题，解决方案是创建如下的script.sql：
With sqlplus, you can pass parameters to your sql. i.e. sqlplus login/password@database @commands.sql 345 654 342 in the exaple , "commands.sql" is the text file containing sql, and "345 654 342" are the values I am passing to the "&1 &2 &3" variables respectivily. There...
the current value of text is registered. textspecifies the text to register when no script is being run or when APPINFO is OFF, which is the default. The default for text is "SQL*Plus". If you enter multiple words for text, you must enclose them in quotes. The...
I want to call sqlplus from Perl, but passing parameters, I do not want use DBI, it's a simple call.. What shoud I correct?Notes:1. Remember, Oracle end each command with ';' like perl.2. I want to mix variables, inside oracle command put perl variables, see below.3. The ...