Ben Chuanlong Du's Blog

It is never too late to learn.

String in SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Teradata

regexp_instr REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR

  1. trim trim specified pad characters or bytes from a character or byte string

  2. like %, _ like, case-insensitive You can also like any (pattern_1, pattern_2, ...) like all …

Immutable String vs Mutable String

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

advantage of immutable string:

trivially thread safe
    more secure
        more memory efficient in most use cases.
            cheap substrings (tokenizing and slicing)

however, if one has to create many small string, e …

Java Features

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. String in Switch

Java 7 allows use of strings in switch instead of just integers, which make things much more convenient (see the following example).

public void foo(Foo t) {
    String …