Oracle block

set serveroutput on;
DECLARE
   v_result NUMBER;
BEGIN
   v_result := 1 / 0;
   DBMS_OUTPUT.PUT_LINE( v_result );
EXCEPTION
   WHEN ZERO_DIVIDE THEN
      DBMS_OUTPUT.PUT_LINE( SQLERRM );
END;

Similar codes

0 vote144 views1 answer
WHERE not regex in SQL
SQL
0 vote133 views1 answer
Mysql bash execute sql file
SQL
6 votes129 views1 answer
Oracle trigger after logon on database
SQL
0 vote145 views1 answer
Typical max-connect-errors mysql
SQL
0 vote130 views1 answer
Oracle job class
SQL
0 vote144 views1 answer
Postgresql array to rows
SQL
-1 vote168 views4 answers
Sql view postgresql
SQL
1 vote133 views1 answer
Oracle get current schema
SQL
0 vote138 views1 answer
List in one column mysql
SQL
8 votes205 views1 answer
Oracle search code in packages
SQL