HI,

I need some help here.

I have a table say Table A and a target Table B

A is inserting data into B
While doing so every record that is entering B a new incremental value is entered in it.

I m using Oracle for Target i,e target B

How to achieve this.
Please help !

Can i do this with an expression that increments a number everytime a record comes in like --> rownum  = rownum + 1
OR
Do i have to mention tat column as an auto increment using sequence of oracle.
OR
is there another functionality to achieve this ?

Last edited by vital_parsley (2011-12-19 09:51:28)