wants to check whether the table is present or not.

[awais290]

Hi,



sqlplus "abc/abc@db1" @ test.sql

test.sql
--------

select count(*) from table1;

if the table is present in the DB then i want to continue test.sql script. other wise exit. please suggest.

[Ed Dyreen]

Code: Select all

mySQL.EXE test.sql &&goto :continiue ||goto :error

:error
echo.%errorLevel%
exit

:continiue
do something

As far as I know you can't continue an SQL based upon an error. Create physically separate queries and put the logic in between.

[einstein1969]

Hi,



sqlplus "abc/abc@db1" @ test.sql

test.sql
--------

select count(*) from table1;

if the table is present in the DB then i want to continue test.sql script. other wise exit. please suggest.

try something like this.

you may create a script that return 0/1

test_exists.sql:
select count(*) from user_tables where table_name="table1";


and catch output in a for /F %%f in ('sqlplus "abc/abc@db1" @ test_exist.sql') do if "%%f"=="1" sqlplus "abc/abc@db1" @ test.sql

I can not check the output then surely there is something to fix.

einstein1969