My Database is 10.2g
My Forms version is 10.1.2
I need to add a serial number column in my output data in SQL. The query is working perfectly in database SQL but when I write this in Forms I am getting error : encountered the symbol 'OVER' when expecting one of the following...
Sample Data is :
ID THK
650 7.2
650 8.9
980 5.7
720 9.8
720 3.5
720 1.3
651 6.4
651 6.9
Expected output from the query is :
Slno ID THK
001 650 7.2
650 8.9
002 980 5.7
003 720 9.8
720 3.5
720 1.3
004 651 6.4
651 6.9
This is possible through this query
DECODE(ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID),1,DENSE_RANK() OVER (ORDER BY ID),NULL) SLNO
But this is not working in Forms. Can you please help how to run it in Oracle Forms?