Skip to Main Content

Analytics Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Serial Number Column

BachanDec 31 2008 — edited Jan 5 2009
Hi All,

I want a to add a column in my report which will be just a serial number of the populating records.

I tried to use Rownum function for a new Item but that's not solution for me.

Just want column with serial number.

Thanks in advance

Bachan.

Comments

Sven W.

Useing Edition Based Redefinition (EBR) would solve this problem. It is available since DB version 11.1. and fairly stable since 11.2.0.4.

It would enable you to update a package (or more precisely all PLSQL based code in the database) inside a sphere called "edition". Currently active sessions would run in one edition, whereas you deploy a new version of your application in a new edition. After some testing you will make this new edition the default one.

Eventually the users close their running sessions. Any new sessions will connect to this new edition. After some more days you can drop the old edition.

More info: Edition-based redefinition

Billy Verreynne

Oracle's mod_plsql (see https://docs.oracle.com/cd/A97335_02/apps.102/a90099/feature.htm) did the reset session call at the end.

Create new session. No state set. Make PL/SQL calls and reset state. State is reset after call terminates.

Use a pooled session. State was reset on previous use of session. Make PL/SQL calls and reset state.

Consider the state reset as part of the destructor of a call, and not part of the constructor, of a call.

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

Post Details

Locked on Feb 2 2009
Added on Dec 31 2008
4 comments
709 views