hi

is there try and catch in oracle query

try
{
do some update
}
catch
{
if there was error go to here
}

Hi,

Boolean logic like this and the trapping of errors can be done in SQL*Plus, but you need to use PL/SQL, not SQL!

Please read: http://www.dba-oracle.com/t_ignoring_oracl...rs_in_plsql.htm

See this great reference for details:

http://www.rampant-books.com/book_0501_easy_plsql.htm