Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Aggregating data

user572405Nov 18 2010 — edited Nov 19 2010
I have a table like this :
 Day, Qty
 10, 1
 11, 1
 12, 1
 13, 1
 14, 1
The output that I need to create is a summary data like:
 Day_List, Qty
  10,       1
  11,       1
  12,       1
  13,       1
  14,       1
  10_11,    2
  11_12,    2
  12_13,    2
  13_14,    2
  10_11_12, 3
  11_12_13, 3
  12_13_14, 3
The aggregate data will comprise for any 2 or 3 consecutive days. Thank you,

Kumar

Comments

Alex Keh-Oracle
Answer

You can sell and setup software with the NuGet managed ODP.NET (Oracle.ManagedDataAccess.dll) version if you want. You just have to license the software under a different legal agreement. You don't have to use the Oracle Client.

The OTN license has restrictions to resell. You can contact an Oracle reseller or sales person to acquire a license that will allow you to resell. With that license, you can use then redistribute your application with the managed ODP.NET software.

Marked as Answer by 854903 · Sep 27 2020
854903

Thank you Alex.

I was not conscious of making another contract.

Your answer was very helpful.

I will contact the reseller immediately.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 17 2010
Added on Nov 18 2010
4 comments
397 views