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 vote351 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote356 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote330 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote332 views1 answer
Insert output identity
SQL
1 vote331 views1 answer
Snowflake rename column name
SQL
18 votes350 views3 answers
Get the list of all tables in sql server
SQL
0 vote340 views1 answer
Authentication modes in sql server
SQL
1 vote331 views2 answers
Copy database mysql
SQL
0 vote325 views1 answer
Sql datediff month
SQL
0 vote348 views1 answer
Pgsql is not permitted to log in
SQL