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 ?
Printable View
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 ?
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.