How to compute a timestamp in Oracle (PL/SQL)
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…
Read articleCategory 50 posts
Programming
Writing about Programming.
How to create a copy/backup of a table in Oracle
You can create a backup of a table (structure and data) in Oracle by using the following syntax: The previous example creates the customersbackup table which mirrors the structure and data…
Read articleHow to exclude Subversion hidden directories (.svn) using Ant
Many Java developers already know that Ant is a great build tool. Besides a build tool, you also need a good version control system to manage the various versions of your code. For this…
Read articleHow to commit a single DML statement in Oracle (PL/SQL)
Sometimes you might need to commit a single INSERT, UPDATE or DELETE statement and not the whole main transaction. In such a case you can use an AUTONOMOUS TRANSACTION, a feature that has…
Read article