updating seguence no. using sqlplus

[kris123]

Hi Friends,

I have an existing table A with rows in it.
I am adding a new column seq_no(number) to this table A.
Is there a way (using sqlplus) to update all rows
with a generated sequence no. on this new column?

Thanks again for ur unfailing support.

[nandu]

The following may help you have a sequence number in the column(Though it may not be the one you desire)

Update set = rownum;

- Nandu

[akhadar]

Look into this link

http://asktom.oracle.com/pls/ask/f?p...:831827028200,

[reydp]

hi kris,
take a look in this:
CREATE SEQUENCE BATCH_SEQ INCREMENT BY 1 START WITH
1 MAXVALUE 1.0E27 MINVALUE 1 NOCYCLE
NOCACHE
/
SQL> DESC DEAD_TAB;
Name Null? Type
----------------------------------------- -------- -------------
TRANID NOT NULL NUMBER(15)
WITHOLDING_TAX NUMBER(13,2)
SQL> ALTER TABLE DEAD_TAB ADD (BATCHNO NUMBER(9));

Table altered.

SQL> DESC DEAD_TAB;
Name Null? Type
----------------------------------------- -------- ------------
TRANID NOT NULL NUMBER(15)
WITHOLDING_TAX NUMBER(13,2)
BATCHNO NUMBER(9)
SQL> UPDATE DEAD_TAB SET BATCHNO = BATCH_SEQ.NEXTVAL;

10002 rows updated.

SQL> SELECT BATCH_SEQ.CURRVAL FROM DUAL;

CURRVAL
----------
10002