Anonymous block plsql

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 vote133 views1 answer
Watch mysql command line
SQL
0 vote164 views2 answers
Suse Linux restart MySQL
SQL
0 vote271 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
7 votes147 views2 answers
Sql remove duplicates based on column
SQL
5 votes133 views1 answer
Sql use database
SQL
9 votes136 views4 answers
Postgresql export database
SQL
0 vote129 views1 answer
Convert sql server guid to varbinary
SQL
4 votes119 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
2 votes125 views1 answer
Oracle current date without time
SQL
2 votes195 views1 answer
Tsql copy table
SQL