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

1 vote143 views1 answer
Xampp import sql file command line
SQL
0 vote155 views1 answer
Postgresql print sessions using the database
SQL
11 votes150 views2 answers
Having clause in sql
SQL
1 vote158 views1 answer
Sqlite3 read only
SQL
5 votes148 views1 answer
Mysql count lines
SQL
0 vote234 views1 answer
Bigrock database connection string
SQL
-2 votes154 views2 answers
Union vs union all in sql
SQL
0 vote161 views1 answer
Compare two tables to find unmatched records
SQL
0 vote143 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
2 votes167 views1 answer
Install postgresql centos 5
SQL