Masterwriter Version 1.0.2.33. Maybe not the answer to your question, but there is no need for PL/SQL here: select round(exp(sum(ln(level)))) from dual connect by level. I came up with this code that I like even better than @smnbbrv's answer. It's a great way to check the speed of a machine.

I've been using a variation of this since my Atari 800 ALTER SESSION FORCE PARALLEL DDL PARALLEL 16; ALTER SESSION FORCE PARALLEL DML PARALLEL 16; ALTER SESSION FORCE PARALLEL QUERY PARALLEL 16; with t as ( select /*+materialize*/ rownum i from dual connect by rownum.

PL / SQL PROGRAMS Last updated on. 9 7 5 3 1 The sum of numbers from 1 to 9 = 25 PL / SQL procedure. Given number is prime' n*n).10). How to find sum of odd number between 1 to 100 coding example in PL/SQL.