Comments for sql4oracle.com http://www.sql4oracle.com SQLPLUS scripts for Oracle Applications Mon, 21 Mar 2011 15:17:32 +0100 hourly 1 http://wordpress.org/?v=3.4.2 Comment on Oracle dates and leap seconds… by tlu http://www.sql4oracle.com/?p=504&cpage=1#comment-18 tlu Mon, 21 Mar 2011 15:17:32 +0000 http://www.sql4oracle.com/?p=504#comment-18 Hello sla29970 I am not sure about that. Mean solar second, day or year is based on observations of the earth rotation and that is not constant. The UTC year is kept within .9 seconds of Mean Solar Year - and you can not ajust the Mean Solar Year, but we can ajust the UTC, and is doing that with leap seconds. The UTC is based on constant length seconds (SI seconds) - very well suitet for a computer... Hello sla29970
I am not sure about that. Mean solar second, day or year is based on observations of the earth rotation and that is not constant. The UTC year is kept within .9 seconds of Mean Solar Year – and you can not ajust the Mean Solar Year, but we can ajust the UTC, and is doing that with leap seconds. The UTC is based on constant length seconds (SI seconds) – very well suitet for a computer…

]]> Comment on Oracle dates and leap seconds… by sla29970 http://www.sql4oracle.com/?p=504&cpage=1#comment-17 sla29970 Thu, 20 Jan 2011 06:10:46 +0000 http://www.sql4oracle.com/?p=504#comment-17 oracle is counting mean solar seconds, not UTC seconds. this is a common problem, viz http://www.ucolick.org/~sla/leapsecs/epochtime.html oracle is counting mean solar seconds, not UTC seconds.
this is a common problem, viz
http://www.ucolick.org/~sla/leapsecs/epochtime.html

]]> Comment on sql4oracle.zip by sql4oracle.zip updated with new and updated files |sql4oracle.com http://www.sql4oracle.com/?page_id=426&cpage=1#comment-16 sql4oracle.zip updated with new and updated files |sql4oracle.com Sun, 03 Oct 2010 14:41:10 +0000 http://www.sql4oracle.com/?page_id=426#comment-16 [...] sql4oracle.zip – all scripts for download [...] [...] sql4oracle.zip – all scripts for download [...]

]]> Comment on Excel: All Links by tlu http://www.sql4oracle.com/?page_id=306&cpage=1#comment-15 tlu Fri, 02 Jul 2010 13:11:09 +0000 http://www.sql4oracle.com/?page_id=306#comment-15 The link names are not always perfect - here is some of the funny links in the sheet: CSD_INCIDENTS_NON_SEC_V: and CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID = HZ_PARTY_SITES.PARTY_SITE_ID ICX_PO_DISTRIBUTES_DIFF_V: and ICX_PO_REVISIONS_TEMP.LOCATION_ID = PO_LINE_LOCATIONS_ARCHIVE.SHIPMENT_NUM The link names are not always perfect – here is some of the funny links in the sheet:

CSD_INCIDENTS_NON_SEC_V:
and CS_INCIDENTS_ALL_VL.INSTALL_SITE_USE_ID = HZ_PARTY_SITES.PARTY_SITE_ID

ICX_PO_DISTRIBUTES_DIFF_V:
and ICX_PO_REVISIONS_TEMP.LOCATION_ID = PO_LINE_LOCATIONS_ARCHIVE.SHIPMENT_NUM

]]> Comment on sql4oracle.zip by New script added: wf_oecogs.sql – to run oecogs workflow for a order line http://www.sql4oracle.com/?page_id=426&cpage=1#comment-12 New script added: wf_oecogs.sql – to run oecogs workflow for a order line Thu, 28 Jan 2010 23:01:22 +0000 http://www.sql4oracle.com/?page_id=426#comment-12 [...] sql4oracle.zip – all scripts for download [...] [...] sql4oracle.zip – all scripts for download [...]

]]> Comment on sql4oracle.zip by New scripts for ftp of out and log from applications server to PC http://www.sql4oracle.com/?page_id=426&cpage=1#comment-11 New scripts for ftp of out and log from applications server to PC Thu, 28 Jan 2010 22:51:58 +0000 http://www.sql4oracle.com/?page_id=426#comment-11 [...] sql4oracle.zip – all scripts for download [...] [...] sql4oracle.zip – all scripts for download [...]

]]>