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 vote87 views1 answer
Oracle create table auto generated primary key
SQL
0 vote106 views1 answer
New rails app with mysql
SQL
0 vote84 views2 answers
Azure sql-datenbank
SQL
1 vote115 views1 answer
Show databases mysql docker
SQL
-1 vote81 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote105 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote100 views1 answer
Convert excel into sqllite db using python
SQL
0 vote87 views1 answer
Load utilities in sql server
SQL
0 vote119 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote95 views1 answer
Return size of tables in mysql
SQL