<div>
Hello Sdstuber<br />
Thank you that's just what I am looking for.<br />
<br />
I understand most of the SQL, but I have never seen Connect By before, can you tell me what that line is doing please?<br />
<br />
Regards<br />
<br />
SQLSearcher
</div>


Hello Sdstuber
Thank you that's just what I am looking for.

I understand most of the SQL, but I have never seen Connect By before, can you tell me what that line is doing please?

Regards

SQLSearcher

<div>
Normally connect by is used to create parent-child relationships in a hierarchical query.<br />
In this case though it's being used a simple counter.<br />
Effectively creating a hierarchy where 1 is parent of 2, 2 is parent of 3, and so on.<br />
<br />
simplest example...<br />
<br />
select level from dual connect by level &lt;&nbsp;10<br />
<br />
you can use this technique to generate lots of data for a variety of purposes.
</div>


Normally connect by is used to create parent-child relationships in a hierarchical query.
In this case though it's being used a simple counter.
Effectively creating a hierarchy where 1 is parent of 2, 2 is parent of 3, and so on.

simplest example...

select level from dual connect by level < 10

you can use this technique to generate lots of data for a variety of purposes.

<div>
Brilliant! Thank you very much.
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts Exchange<br />
I want to be able to select each work day date for this month. Can someone provided the SQL I need please?<br />
<br />
So for this month I would get from my select statement all the dates apart from the weekend dates.<br />
<br />
For example.<br />
<br />
WorkDay<br />
---------------<br />
03/08/2015<br />
04/08/2015<br />
05/08/2015<br />
06/08/2015<br />
07/08/2015<br />
10/08/2015<br />
11/08/2015<br />
12/08/2015<br />
13/08/2015<br />
14/08/2015<br />
17/08/2015<br />
18/08/2015<br />
19/08/2015<br />
20/08/2015<br />
21/08/2015<br />
24/08/2015<br />
25/08/2015<br />
26/08/2015<br />
27/08/2015<br />
28/08/2015<br />
31/08/2015<br />
<br />
Regards<br />
<br />
SQLSearcher
</div>
</div>


Hello Experts Exchange
I want to be able to select each work day date for this month. Can someone provided the SQL I need please?

So for this month I would get from my select statement all the dates apart from the weekend dates.

For example.

WorkDay
---------------
03/08/2015
04/08/2015
05/08/2015
06/08/2015
07/08/2015
10/08/2015
11/08/2015
12/08/2015
13/08/2015
14/08/2015
17/08/2015
18/08/2015
19/08/2015
20/08/2015
21/08/2015
24/08/2015
25/08/2015
26/08/2015
27/08/2015
28/08/2015
31/08/2015

Regards

SQLSearcher

SQL Oracle Select all work days for this month.

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.