Plsql 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

13 votes159 views2 answers
Check if value is null mysql
SQL
0 vote182 views1 answer
Is not numeric sql
SQL
0 vote169 views1 answer
Mysql count number of occurrences in a column
SQL
10 votes118 views1 answer
Oracle view dependencies
SQL
5 votes270 views1 answer
Oracle asynchronous procedure
SQL
5 votes182 views1 answer
Oracle asynchronous update
SQL
3 votes174 views2 answers
How to load files in mysql
SQL
8 votes207 views2 answers
Sqlsrv default port
SQL
1 vote175 views1 answer
How to fetch alternate records from two tables
SQL
0 vote168 views1 answer
Sql server query database space available
SQL