Skip to Main Content

Java APIs

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!

generics extends to 2 types

843793Jun 12 2010 — edited Jun 12 2010
hi,
i have this class ReadFiletoLabelledRelationDiagonal, that read values from a file to a object.

how can i restrict the type of input, for example
ReadFiletoLabelledRelationDiagonal<? extends Integer>
and
ReadFiletoLabelledRelationDiagonal<? extends Double>

Comments

SmithJohn45

can you give some " sample data " like this:

with t as (Select 'account01' as account_name, '1990' as year, 'Jan' as month from dual
           Select 'account02' as account_name, '2000' as year, 'Feb' as month from dual
)
select ( your query here ) from t;

the seniors can help after checking the actual results of your query will return.
Help seniors to help yourself...

Stax
SQL> ed
Wrote file afiedt.buf


  1  with t (account_name,year,month,sal) as (
  2   select 'u1','2022','January',150 from dual union all
  3   select 'u1','2022','February',200 from dual union all
  4   select 'u1','2022','March',300 from dual
  5  )
  6  select
  7    t.*
  8   ,sum(sal) over (partition by account_name order by  to_date(month||year,'MonthYYYY','NLS_DATE_LANGUAGE=AMERICAN')) ssal
  9* from t
SQL> /


AC YEAR MONTH           SAL       SSAL
-- ---- -------- ---------- ----------
u1 2022 January         150        150
u1 2022 February        200        350
u1 2022 March           300        650


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

Post Details

Locked on Jul 10 2010
Added on Jun 12 2010
2 comments
211 views