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

1 vote196 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote164 views1 answer
Oracle list of long running queries
SQL
0 vote169 views1 answer
Oracle array
SQL
0 vote214 views1 answer
How to check rollback status in oracle
SQL
0 vote178 views1 answer
Doesn't have default value mysql
SQL
0 vote169 views1 answer
Sql mod even odd
SQL
0 vote181 views1 answer
Sql with example
SQL
0 vote172 views1 answer
Storing RGBA in mysql db
SQL
0 vote174 views1 answer
Sqlite get date only
SQL
1 vote176 views1 answer
Postgresql blocked on mac
SQL