Oracle block

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

3 votes144 views2 answers
Brew start mysql
SQL
0 vote202 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote136 views1 answer
Oracle tablespace autoextend
SQL
0 vote134 views1 answer
Call function sql oracle
SQL
0 vote153 views2 answers
Connect to mysql server mac terminal
SQL
0 vote183 views1 answer
Sparql if bound query
SQL
1 vote151 views2 answers
Oracle list partitioned tables
SQL
0 vote143 views1 answer
Sql server split string and insert into table select
SQL
1 vote148 views3 answers
Mysql parse int
SQL
0 vote146 views3 answers
ChAnge TABLE name apex oracle
SQL