Archive for June, 2009
Wednesday, June 24th, 2009
Google android makes it possible to define a GUI layout using XML file (http://lamp.epfl.ch/~linuxsoft/android/android-m3-rc37a/docs/devel/ui/xml.html). Couple projects used this feature to build a rich GUI development
http://www.droiddraw.org/ - browser java plug-in
http://www.artfulbits.com/Android/Stencil.aspx - Visio prototype stencil
Posted in Mobile Development | No Comments »
Friday, June 12th, 2009
http://www.oracle-dba-online.com/sql/oracle_table_partition.htm
http://www.psoug.org/reference/select.html
Posted in Databases | No Comments »
Thursday, June 4th, 2009
It is a bit challenging to get UTC time stamp using Oracle PL/SQL. I found the following trick
SELECT (CAST(SYS_EXTRACT_UTC(systimestamp) AS DATE) - TO_DATE('19700101', 'YYYYMMDD')) * 86400 seconds FROM dual;
On Joels Blog:
http://discuss.joelonsoftware.com/default.asp?joel.3.240795.5
Other way is here:
http://www.lifeaftercoffee.com/2005/10/20/unix-timestamp-to-oracle-date-conversion/
Posted in Databases | No Comments »