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 vote115 views1 answer
Oracle sql assign unique number to each grouping
SQL
-1 vote110 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote120 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote129 views1 answer
What is a Database?
SQL
3 votes116 views2 answers
Sqlite show table definition
SQL
0 vote125 views1 answer
Mysql listing get a particu particular user firsdt
SQL
9 votes112 views1 answer
Identity insert on sql server
SQL
0 vote118 views1 answer
Get last updated row sql server
SQL
0 vote119 views1 answer
Sql server split string and insert into table select
SQL
-1 vote131 views1 answer
Auto increment psql not primary key
SQL