Oracle Substring & Instring Functions Substr Instr

Oracle Substring & Instring Functions Substr Instr


Substring Beginning Of String
SELECT SUBSTR(, 1, )
FROM dual;

SELECT SUBSTR('Take the first four characters', 1, 4) FIRST_FOUR
FROM dual;

Substring Middle Of String
SELECT SUBSTR(, , )
FROM dual.

SELECT SUBSTR('Take the first four characters', 16, 4) MIDDLE_FOUR
FROM dual;

Substring End of String
SELECT SUBSTR(, )
FROM dual.
SELECT SUBSTR('Take the first four characters', 16, 15) SIXTEEN_TO_END
FROM dual;

Java Examples: Convert double to string

How many times do I have to do this?

:)


Java Examples: Convert double to string: "public class ConvertDoubleToString {
public static void main(String[] args) {
double aDouble = 0.11;
String aString = Double.toString(aDouble);
}
}"

test

!Links: "code"