SerialNo [message #346181] |
Sun, 07 September 2008 01:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 625 Registered: August 2002
|
Senior Member |
|
|
Dear sir,
i want to generate a serial no in column formula which is not in table fileds.pls advised how i write this procedure?
regards
Required Out Put.
1
2
3
4
5
6
7
8
9
...and so on
|
|
|
Re: SerialNo [message #346209 is a reply to message #346181] |
Sun, 07 September 2008 06:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Hm, do you want to create this "serial number" in front of actual data in your report, or would you like to simply create a report which contains nothing but serial numbers?
If you want to use a "summary" column, its function should be "Count", choose your source column and group it should be broken on.
Otherwise, you might want to check Row Generator Techniques.
|
|
|