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

1 vote202 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote206 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote186 views1 answer
Sql select merge multiple values
SQL
0 vote190 views1 answer
Update if else mysql
SQL
0 vote200 views1 answer
Reset postgresql password windows
SQL
3 votes185 views1 answer
Oracle apex warning message
SQL
0 vote190 views1 answer
Sql add calculated column
SQL
0 vote192 views1 answer
Sqlite3 update select
SQL
0 vote205 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote195 views1 answer
Difference between min and max date sql
SQL