varchar sequence

[Sonia]

Hi,
I need a varchar sequence of number.

Say, i want something like PQ1,PQ2,PQ3,PQ4......

Using sequence i can generate, only number. How can i generate or conacatenate the char with the numbe and insert into a table ?

[KenEwald]

I haven't tried this code out, but I'd try something like this...

insert into mytable (id) values ('PQ'||to_char(mysequence.nextval));

I'm assuming "PQ" is a constant.