Re: [GENERAL] getting the currval of a sequence

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;

// 
// 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!
// 
// -Fran
// 
// 
// 

--
SA, software.net         My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings 
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE 
L_______________________ I hope the answer won't upset her. ____________