Dev-Notes.com RSS Service

Sorting arrays in Javascript

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

This note describes how to sort a simple array and an array of objects in Javascript.

Prevent Excel from recognizing a string as a number when opening CSV files

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

When using Microsoft Excel to open a CSV file, at times a string may appear like a number, causing Excel to open it in a wrong format. This note offers one solution for this problem.

Creating a Queue in Oracle

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

Oracle Advanced Queuing provides a medium for various applications to communicate with each other, providing the infrastructure for SOA, for example. This note provides an example on how to set up a queue.

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.