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

5 votes353 views1 answer
Oracle ORA-00054 origin
SQL
1 vote342 views1 answer
Sql only five first row
SQL
0 vote426 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
5 votes346 views1 answer
Oracle sysdate
SQL
1 vote356 views1 answer
Oracle create index if not exists
SQL
4 votes393 views2 answers
Float postgres
SQL
0 vote349 views1 answer
Call procedure in wordpress
SQL
0 vote375 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote419 views1 answer
Postgres - Login and connect as default user
SQL
1 vote356 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL