Dev-Notes.com RSS Service

Calculating the difference between two dates or times in DB2

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note demonstrates how to calculate the difference between two dates or two times, ie. timestamps, in a DB2 SQL inline function.

Using dummy table to select pseudocolumns

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note illustrates how to use a dummy table to select pseudocolumns in Oracle and DB2 databases.

Java method to convert a string to proper or initial case

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note provides a simple Java method for converting a string to have proper case, or in other words, each word will have its initial letter capitalized.

Java method to round a number to specified decimal places

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note provides a simple method for rounding a number to a specified number of decimal places in Java.

Manually incrementing an Oracle sequence by a defined amount

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note shows how you can instruct Oracle to advance an Oracle sequence by an amount that you define.

Javascript delay function

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

Sometimes we need to delay the execution of Javascript code for certain amount of time. This simple example allows that functionality.

How to use the ampersand (&) symbol in SQL statements as a literal value

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note provides two ways for you to use the ampersand symbol, "&", as a literal value in an Oracle SQL statement.

Using Oracle RMAN to duplicate a database

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note illustrates how to use Oracle 11g's RMAN utility to duplicate a database.

Inserting multiple records at once into a database table

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This note provides a sample for how to insert multiple records into a database table with only one insert statement. This provides a more efficient way to insert data into a table than calling multiple statements.

Shorten long URLs with Perl, cURL, and the short.to API

C. Peter Chen — Thu, 01 Jan 1970 00:00:00

This sample Perl script illustrates how to use the cURL::Easy extension of libcurl to use short.to's API to shorten long URLs.