is it possible

[radhikams]

Will it be ppossible to create a sequence for a varchar field of a table?????

thanks

[debasisdas]

Directly speaking NO. because for sequence all the values are numbers not even float.

But you can create a sequence and concatinate with some character and use.

[subashsavji]

No.
Craete Serial Number And Incorporatre As New Column While Running.
You Can Create By Using Cursor,loop And Counter. And Increment Counter Upto End Of Cursor.

[pravatjena]

create table test (id varchar2(20));

Table Created.

create sequence s1;

insert into test values(s1.nextval);

1 row inserted.

But u cant use this sequence for arithmatic calculation.