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

3 votes312 views1 answer
How to get yesterday date in sql
SQL
0 vote216 views1 answer
Enable Rabbitmq management plugin
SQL
6 votes208 views2 answers
Drop foreign key
SQL
0 vote220 views2 answers
Imageview setimageresource null
SQL
0 vote217 views1 answer
Max mysql
SQL
0 vote251 views1 answer
Capabilities of sql select statements
SQL
15 votes203 views2 answers
How to drop database name in postgresql
SQL
54 votes342 views6 answers
Sql rename column
SQL
36 votes275 views6 answers
Change column data type sql
SQL
0 vote218 views1 answer
Oracle merge insert if not exists
SQL