Oracle 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 vote353 views1 answer
Get who is hired in february in sql
SQL
0 vote362 views1 answer
Compare subqueries oracle
SQL
0 vote322 views1 answer
Automate mysql cli query
SQL
0 vote353 views2 answers
Jsonb
SQL
3 votes354 views1 answer
Set default today mysql
SQL
13 votes330 views2 answers
Display users in mysql
SQL
0 vote378 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote343 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote407 views1 answer
Eliminate zero from integer mysql
SQL
17 votes358 views4 answers
Sort by mysql
SQL