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

50 votes205 views6 answers
Sql count duplicate rows
SQL
0 vote109 views1 answer
Increase speed of like queries postgres
SQL
0 vote112 views2 answers
Mysql dump database tables only
SQL
0 vote113 views1 answer
View to table
SQL
0 vote110 views2 answers
How to use aggregate functions in sql
SQL
0 vote104 views1 answer
Oracle activate program
SQL
0 vote103 views1 answer
Postgre admin slow
SQL
14 votes108 views3 answers
Delete all records from table except sql
SQL
1 vote107 views4 answers
Get week day from date in sql
SQL
0 vote110 views1 answer
Get db connection detail from sql developer profile
SQL