Re: finding user sequences and values

In article <1076935173.330.0_at_damia.uk.clara.net>, Tom says...
> Hi
>
> 9i on Linux
>
> How do i find the sequences that are associated with a particular user and table? I need to query this value and then increment it
> by around 1000.
> Can anyone assist me with that?
>

Hi Tom, sequences are not tied to tables in any way.

To see what sequences are owned by a user:

select * from user_sequences;

-- 

jeremy