dustin sallings wrote:
>
> On Fri, 14 Aug 1998, Fran Fabrizio wrote:
>
> If you've recently done an insert and want to know what the value
> was, you can do this:
>
> select last_value from mysequence;
NO! This is wrong!
Use currval('_seq_name_') !!!
>
> //
> // Hi all,
> //
> // I need to do the equivalent of:
> //
> // select my_sequence.CURRVAL from Sys.dual;
> //
> // so I'm guessing its:
> //
> // select currvar('my_sequence') from ???????;
> //
> // Can anyone fill in the ???? Thanks!
> //
Vadim