Hi guys, I have a query with oracle 10g:
select "+(distinct?"distinct ":"")+ " a " +" from TABLE (SYS.ODCINUMBERLIST( 86, 103, 35, 73, 78, 116, 45, 84, 97, 121, 89, 28, 93, 69, 161, 63, 21, 2, 81, 1, 109, 67, 80, 119, 88, 51, 77, 65, 53, 58, 87, 29, 113, 27, 104, 55, 3, 22, 46, 48, 71, 59, 32, 92, 37, 66, 100, 115, 52, 72, 76, 91, 33, 61, 39, 106, 36, 95, 124, 64, 120, 79, 96, 42, 31, 75, 30, 57, 112, 123, 68, 111, 26, 47, 101, 114, 24, 50, 70, 56, 49, 107, 23, 110, 94, 34, 43, 102, 122, 108, 141, 41, 85, 25, 44, 117, 90, 54, 38, 105, 4, 74, 98, 40, 118, 62, 60, 5, 83, 99, 82)) as s LEFT JOIN "+tableName+" as a ON a.currencyId = s.COLUMN_VALUE" ORDER BY s.COLUMN_VALUE);
it works fine in jdbc but it is not work with hql . it can't recognize the "from TABLE (...)"
so anyone can help and has any suggestion? Thanks!
|