Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating IDs subsequently

Re: Creating IDs subsequently

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Fri, 25 Jul 2003 12:53:37 GMT
Message-ID: <3F212851.66D3AE06@remove_spam.peasland.com>


Sure, you can write routines that compute time in fractional seconds, using Java or External C calls. Heck, you can even do this in PL/SQL with the GET_TIME function. But the trick comes in storing those computed values and doing date arithmetic with them!!!!

Cheers,
Brian

Billy Verreynne wrote:
>
> andrewst <member14183_at_dbforums.com> wrote
>
> > TIMESTAMP goes down to fractional seconds, but Gerd has already said he
> > doesn't have Oracle 9.
>
> But that can be written as a Java function in Oracle 8 to provide the
> same functionality that is available in Oracle 9.
>
> --
> Billy

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Fri Jul 25 2003 - 07:53:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US