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 vote161 views1 answer
Delete double on SQL with multiple primary keys
SQL
11 votes177 views3 answers
Change column name sql server management studio
SQL
0 vote177 views1 answer
Mysql beautifier terminla
SQL
3 votes162 views2 answers
Plsql print
SQL
0 vote160 views1 answer
Concatenate columns in table
SQL
-1 vote156 views1 answer
What is in operator
SQL
0 vote210 views1 answer
Creating sqeuence in oracle database
SQL
17 votes204 views2 answers
T_sql contains
SQL
0 vote178 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote200 views1 answer
Mysql 3 months ago
SQL