On 12/14/05, Roland Giesler <roland(at)giesler(dot)za(dot)net> wrote:
> Is it possible to create a sequence like 'ABC012','ABC013', etc. in a
> char(6) column?
>
i guess you can do something like:
create sequence seq1;
create table tt (
...
fld1 char(6) default 'str' || nextval('seq1'),
...
);
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)