Re: Usage of RowId...

From: <cmohan_at_iname.com>
Date: 1998/04/13
Message-ID: <6gtec3$5jr$1@nnrp1.dejanews.com>#1/1

I am not sure what is "optimistic" concurrency. But you can use the DATE datatype to implement concurrency. DATE datatype, infact stores the time also. You may want to try the following to get an idea of the DATE type.

select to_char(sysdate,'dd-mon-yyyy.hh:mi:ss') from dual;

If you are looking for microsecond component, I am not sure how to get that.

Hope this helps,
CM

In article <6gnqgc$86d$1_at_ha2.rdc1.md.home.com>, "Brian K. Lawton" <NOSPAM.Lawton_at_RDAConsultants.Com> wrote:
>
> If I'm trying to implement optimistic concurrency within my database, is the
> RowId attribute the correct place to be checking? If not, what is Oracle's
> equivalent to SQL Server's timestamp datatype?
>
> ________________________________________________
> Brian K. Lawton (mailto:Lawton_at_RDAConsultants.com)
> RDA Consultants Limited (http://www.RDAConsultants.com)
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 13 1998 - 00:00:00 CDT