<div>
You can just use the function in a SQL statement, like:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42359743-1"><span>select id, start_date, end_date, function_name(start_date, end_date) as newfield from table1;</span>
</code></pre>
<hr />
»<b><i>bp</i></b>
</div>


<div>
U can &nbsp;do like this-<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42359745-1"><span>SELECT id, start date, end_date,yourfunction(start date, end_date)  workingdays</span>
<span>from yourtable</span>
</code></pre>
</div>


<div>
I'm currently using PL SQL Developer;<br />
<br />
My code is below, and when I run it in SQL Window, I get a message &quot;Done&quot;, but I don't see the results. <br />
I tried following: <br />
1) replacing the select statement to with &quot;Create table as&quot; and shows &quot;Done&quot; but I don't see the table<br />
2) I tried putting &quot;/' after the function and when I run it, it gives me an error &quot;ORA 06575 Package or Function in an invalid state&quot;<br />
<br />
<br />
CREATE OR REPLACE FUNCTION work_days_between(p_date1 IN DATE, p_date2 IN DATE)<br />
&nbsp; &nbsp;RETURN BINARY_INTEGER<br />
IS<br />
&nbsp; &nbsp; v_holidays BINARY_INTEGER;<br />
&nbsp; &nbsp; v_weekdays BINARY_INTEGER := 0;<br />
&nbsp; &nbsp; v_date &nbsp; &nbsp; DATE := TRUNC(p_date1);<br />
BEGIN<br />
&nbsp; &nbsp; WHILE v_date &lt;= p_date2<br />
&nbsp; &nbsp; LOOP<br />
&nbsp; &nbsp; &nbsp; &nbsp; IF TO_CHAR(v_date, 'Dy') NOT IN ('Sun', 'Sat')<br />
&nbsp; &nbsp; &nbsp; &nbsp; THEN<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; v_weekdays := v_weekdays + 1;<br />
&nbsp; &nbsp; &nbsp; &nbsp; END IF;<br />
&nbsp; &nbsp; &nbsp; &nbsp; v_date := v_date + 1;<br />
&nbsp; &nbsp; END LOOP;<br />
<br />
&nbsp; &nbsp; SELECT COUNT(*)<br />
&nbsp; &nbsp; &nbsp; INTO v_holidays<br />
&nbsp; &nbsp; &nbsp; FROM HOLIDAYS<br />
&nbsp; &nbsp; &nbsp;WHERE observed BETWEEN p_date1 AND p_date2;<br />
&nbsp; &nbsp; RETURN v_weekdays - v_holidays;<br />
END;<br />
--/ &nbsp; &gt;&gt;&gt;&nbsp;Tried add as an option, but giving me &quot;invalid state&quot; error... <br />
<br />
<br />
select t.subscriber_id, t.elig_start_date, t.elig_end_date, work_days_between(t.elig_s<wbr />tart_date,<wbr /> t.elig_end_date) newfield<br />
from table t;<br />
<br />
Thanks
</div>


<div>
PL SQL Developer is used with Oracle, not SQL Server. <br />
<br />
Are you working with Oracle, or with Microsoft SQL Server?
</div>


<div>
To: Scott McDaniel <br />
I'm working with Oracle. <br />
<br />
To: Bill Prew <br />
Yes I do have HOLIDAYS table and I wrote tried your code and it is giving me an error &quot;ORA-06575: Package or function &quot;WORK_DAYS_BETWEEN is an invalid state&quot;<br />
<br />
Thanks
</div>


<div>
If that function is in the schema now I would try removing it, then re-adding it, maybe it got messed up in earlier activities.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
To Bill Prew:<br />
By you validating my code actually pointed me to the right directions. My oversight was &quot;observed &quot;, where in my Holidays table I called the column &quot;HOL_DATE&quot;. From here I was able to run the function and use it in a query which produced my desired results. Thank you!
</div>


<div>
Thanks Bill Prew appreciate it. <br />
<br />
Although Pawan Kumar also assisted with my initial question, I end up giving all the points to Bill Prew because I didn't know how to divide the score 750 (Bill Prew)/250 (Pawan Kumar).
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
I have a broad question so please bare with me on this. I posted a question regarding how to calculate a working days using a holidays table. So now I have a function working. <br />
<br />
But my question, how to call/execute this function so that I can run it against a table. (Kinda similar to MS Access queries work).<br />
I've been searching the web but I just don't how what's the best practice. Example:<br />
I have a function that accepts 2 dates and returns an integer number. (e.g., function_name (a date, b date) and returns the a number. <br />
My table columns: id, start_date, end_date. <br />
My expected results if possible: id, start date, end_date, &quot;the number returned from the function&quot;<br />
<br />
Thank you.
</div>
</div>


Hello,
I have a broad question so please bare with me on this. I posted a question regarding how to calculate a working days using a holidays table. So now I have a function working. 

But my question, how to call/execute this function so that I can run it against a table. (Kinda similar to MS Access queries work).
I've been searching the web but I just don't how what's the best practice. Example:
I have a function that accepts 2 dates and returns an integer number. (e.g., function_name (a date, b date) and returns the a number. 
My table columns: id, start_date, end_date. 
My expected results if possible: id, start date, end_date, "the number returned from the function"

Thank you.

PL SQL Developer

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.