<div>
<div class="content wysiwyg-content">
i need to write a query that outputs the date that is 20 working days in the future from today.<br />
<br />
so for example if i ran the query today (18-02-2015) the output would be 18-03-2015. <br />
The query would exclude weekend days and bank holidays. <br />
<br />
I have a table called non_working_days which ill need to use somehow! the structure is:<br />
<br />

<pre><code id="code-10-28619139-1">NWD_ID	NWD_DATE	NWD_REASON
J1416	21-Feb-15	WEND
J1417	22-Feb-15	WEND
J1418	28-Feb-15	WEND
J1419	01-Mar-15	WEND
J1420	07-Mar-15	WEND
J1421	08-Mar-15	WEND
J1422	14-Mar-15	WEND
J1423	15-Mar-15	WEND
J1424	21-Mar-15	WEND
J1425	22-Mar-15	WEND
J1426	28-Mar-15	WEND
J1427	29-Mar-15	WEND
J1428	03-Apr-15	BHOL
J1429	04-Apr-15	WEND
J1430	05-Apr-15	WEND
J1431	06-Apr-15	BHOL

etc.</code></pre>
<br />
any help to write the query is appreciated
</div>
</div>


i need to write a query that outputs the date that is 20 working days in the future from today.

so for example if i ran the query today (18-02-2015) the output would be 18-03-2015. 
The query would exclude weekend days and bank holidays. 

I have a table called non_working_days which ill need to use somehow! the structure is:

(CODE)

any help to write the query is appreciated

calculating 20 working days into future - oracle sql

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.