Navigation
Recent Posts
- Macro to insert footer
- $this PHP Variable
- php5 extensions directory and mysql undefined function
- Windows Vista biggest disappointment of 2007
- Excel giving incorrect results
- SnagIt 8.2.0 workaround
- Find Matching Text in Excel
- Excel macro to copy to Custom Template
- UK Post Code GeoCoding
- Accept User Input in SQL*Plus
- Exit SQLPlus from Batch File
- Run Multiple SQLPlus Queries via DOS batch file
- CSS Browser Differences IE and Firefox
- Create csv import file from Excel
- Use Query Result as Variable in Batch File
Archive
- November-2009
- August-2008
- January-2008
- December-2007
- November-2007
- October-2007
- September-2007
- August-2007
- June-2007
- May-2007
- April-2007
- March-2007
- February-2007
- January-2007
Popular Tags
Click tag to retrieve blogsExit SQLPlus from Batch File
If you have a batch file set to run multiple SQLPlus queries and to then perform some other action such as merge the results together into a single file, or copy the files elsewhere you need to physically exit SQLPlus or the batch file will not continue to run and execute the commands.
To exit SQLPlus automatically skip a line after your last query and type exit as in
@C:\Queries\Query_2.sql
@C:\Queries\Query_3.sql
@C:\Queries\Query_4.sql
EXIT
Tags:SQLPlus |Oracle |DOS |bat |batch file
Run Multiple SQLPlus Queries via DOS batch file
To run multiple SQLPlus queries as part of a DOS batch file place all the queries in a separate SQL file. For Example
@C:\Queries\Query_2.sql
@C:\Queries\Query_3.sql
@C:\Queries\Query_4.sql
Save the file as runall.sql. Then use this file in your batch file
sqlplus [login details] @C:\queries\runall.sql
EXIT
Tags:SQLPlus |bat |DOS |Oracle
Use Query Result as Variable in Batch File
You can use the result of a SQLPlus query as a variable in a windows batch file by spooling the output to a .bat file
SET NEWPAGE 0
SET SPACE 0
SET PAGESIZE 0
SET WRAP OFF
SET LINESIZE 1000
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF
SPOOL c:cdr_count.bat;
select
'@echo off' from dual
UNION ALL
select
'SET CDR='||''||count(ddi) from cdrs where trunc(sysdate) = trunc(adj_start_time);
SPOOL OFF;
This creates or replaces a batch file and outputs
@echo off
SET CDR=643950
I am then able to call that batch file from within another batch file and use the SQL query result as it is defined as a variable.
call c:cdr_count.bat
IF %CDR% EQU 0 GOTO END
Tags:SQLPLus |Oracle |DOS |Batch files