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

1 vote329 views1 answer
Postgres check blocking
SQL
11 votes332 views6 answers
Distinct sql
SQL
1 vote320 views1 answer
Snowflake rename column name
SQL
4 votes300 views1 answer
Sql data types
SQL
0 vote307 views1 answer
Check duplicate values plsql
SQL
4 votes304 views1 answer
Check database name postgresql
SQL
0 vote361 views1 answer
Mysql relationships between tables
SQL
0 vote357 views1 answer
Insert query return id mysql
SQL
0 vote294 views1 answer
Insert or update cassandra
SQL
5 votes309 views1 answer
How to use rank function in sql
SQL