Format Numbers Oracle

Hi

I got a table named books with its field name Accno (access number) and author (Name of the author).

i created a sequence with the following syntax

create sequence seqbook increment by 00000001 start with 000000001 maxvalue 99999999 minvalue 00000001 nocycle cache 4;

and Oracle created the sequence.

after that i inserted it into the table

insert into books values(seqbook.nextval, 'Joseph');

and oracle inserted the values into the table books

and while querying "select * from books;"

Accno                    Author
1                           Joseph

I wanted the access number to be stored in as 00000001 insted of 1. what should i do in order to get the output like 00000001.

Thanks in advance.
Thanks & regards
Shiljo Received on Wed Mar 15 2006 - 00:39:28 CST