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

0 vote209 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote187 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote216 views1 answer
Oracle tablespace autoextend
SQL
0 vote199 views3 answers
Between keyword sql
SQL
0 vote203 views1 answer
How to put is null in where in clause
SQL
0 vote168 views1 answer
Mysqli or pdo
SQL
4 votes223 views6 answers
Sql select statement
SQL
0 vote217 views1 answer
Get clob size oracle
SQL
5 votes197 views1 answer
How to check nls format in oracle
SQL
0 vote201 views1 answer
Change data type in mysql
SQL