Re: Creating IDs subsequently

Brian Peasland <dba_at_remove_spam.peasland.com> wrote i

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

Er.. what trick? You store it in decimal format (as C++/Delphi/etc. does it too).

Then you use standard maths on it (as C++/Delphi/etc. does it too). If it makes the SQL statement a tad complex with too many nested bracket expressions, you wrap that into a PL/SQL function.

This is not a problem that requires "tricks" to solve. Just plain logic using standard Oracle features.

--
Billy