Blog

How to compute a timestamp in Oracle (PL SQL)

Posted: 2007-10-09   |   Categories: Oracle, Programming

Many sources use the term timestamp to refer specifically to Unix time, the number of seconds since 00:00:00 UTC on January 1, 1970. In Oracle you can compute this number very easily. For example, the following query computes the number of seconds between 00:00:00 UTC on January 1, 1970 and October 9, 2007.

   
SELECT (to_date('09-10-2007', 'DD-MM-YYYY') -
to_date('01-01-1970', 'DD-MM-YYYY')) * 60 * 60 * 24
FROM dual

The result of the preceding query should be 1191888000.

Very Useful Shortcuts for Eclipse

Posted: 2007-09-25   |   Categories: IDE, Java   |   Tags: Eclipse

Who uses eclipse already knows how fantastic this great IDE is. Here I want to provide a table with the shortcuts I use almost ever when I develop in Java.

Action Shortcut

How to attach source or Javadoc to Java Enterprise Edition API in Eclipse

Posted: 2007-09-14   |   Categories: IDE, Java   |   Tags: Eclipse

Eclipse is a great IDE. When you hover your mouse over a class name or method of the Java SE API you get a contextual help for that class or method. However if you do the same thing over a Java EE class, such as HttpServletRequest you might not get the same effect. This is because there’s is no source or Javadoc attached to that class. To attach the documentation to your J2EE class as well you can follow these steps:

How to create a copy/backup of a table in Oracle

Posted: 2007-07-04   |   Categories: Oracle, Programming

You can create a backup of a table (structure and data) in Oracle by using the following syntax:

 
CREATE TABLE customers_backup AS (SELECT * FROM customers)

The previous example creates the customers_backup table which mirrors the structure and data of the customers table.