Commit complete.

[email protected]> select * from test1;

KEYVAL DATAVAL
---------- --------------------
1
2
3

[email protected]> update test1 set keyval = rownum;

it should be:

KEYVAL DATAVAL
------------ ------------------
UUUUUUUU 1
UUUUUUUU 2
UUUUUUUU 3

Last will be:

KEYVAL DATAVAL
------------ ------------------
1UUUUUUU 1
2UUUUUUU 2
3UUUUUUU 3

"U" represents for spaces.

And or U can do update test1 set keyval = rowid based on what U really want, and of course U shoul change the keyval datatype to VARCHAR2.

Which version are U using? If under ORACLE 8i then
use execute immediate new feature.

Take care

[Edited by mber on 01-23-2001 at 04:29 PM]