Re: Does Sequence take up database storage?

junwen wrote:
>
> Hi,
>
> Can anybody tell me what is the use of sequence and does it take up any
> storage in database
> ?
>
> Regards,
> Junwen

Sort of - they are in SEQ$ - one row per sequence - hardly anything at all.

They are very useful for populating columns that require a unique value for every row in a table.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse