Re: about sequence
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Wed, 20 May 2009 09:57:46 +0300
Message-id: <4A13A9EA.5000709_at_inter.net.il>
Inline
Date: Wed, 20 May 2009 09:57:46 +0300
Message-id: <4A13A9EA.5000709_at_inter.net.il>
Inline
Adar Yechiel
Rechovot, Israel
Mohammed Mehraj hussain wrote:
> hi,
> I've a EMP table and it uses EMP_SEQ sequence to generate the EMPNO...
>
> I know the above information as i created the sequence ..
> But how come the other person knows that so and so sequence is used on
> this table EMP..
>
I think that if you use the sequence in a pl/sql procedure or package he
can find it easily.
> So that the person knows the max value etc...
>
Select * from all_sequences?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 20 2009 - 01:57:46 CDT