<div>
You can avoid it ..<br />
check that if you are dividing with 0 then devide it with 1.
</div>


<div>
instead of doing a/b you need to do<br />
CASE WHEN b=0 THEN 0 ELSE a/b END
</div>


<div>
Sorry guys not an oracle programmer i'm simply just fixing some cold fusion applications.<br />
<br />
Where about would I add this. In the actual select?<br />
<br />
<br />

<pre><code class="code-1 nolinks" id="code-120542"><span>select ((booked_slots / available_slots) * 100) as frequency, ((numbers_booked / seatcap_booked) * 100) as occupancy , year</span>
<span>from surveystats</span>
<span>where room_number = &lt;cfqueryparam value=&quot;#buildings#.#rooms#&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;</span>
<span>order by year</span>
</code></pre>
</div>


<div>
Thanks schwertner but I've received another error message;<br />
<br />
ORA-00904: &quot;AVALAIBLE_SLOTS&quot;: invalid identifier
</div>


<div>
avalaible ----&gt;available<br />
<br />
Sorry for the typo!
</div>


<div>
<div class="content wysiwyg-content">
Now I know the reason behind this error is because I'm trying to divide by zero as I've figured that out in the back end. <br />
<br />
My only problem is fixing it. I've researched and found out that others have used DECODE &amp;&nbsp;SUM to resolve these issues but I can't seem to get it working.
</div>
</div>


Now I know the reason behind this error is because I'm trying to divide by zero as I've figured that out in the back end. 

My only problem is fixing it. I've researched and found out that others have used DECODE & SUM to resolve these issues but I can't seem to get it working.

ORA-01476: divisor is equal to zero

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.