ﾌﾟﾛｸﾞﾗﾑとSQLの文字列結合

JAVAの場合

           手法１プラス演算子（時間がかかる）
           String s1 = "aaa";
           String s2 = "bbb";
           String s = s1 + s2;

           手法２String#concat()（時間がかかる）
           String s1 = "aaa";
           String s2 = "bbb";
           String s = s1.concat(s2);

           手法３StringBuffer
           String s1 = "aaa";
           String s2 = "bbb";
           StringBufferbuf = new StringBuffer();
           buf.append(s1);
           buf.append(s2);
           String s = buf.toString();

           手法４StringBuilder（一番速度が速い）
           String s1 = "aaa";
           String s2 = "bbb";
           StringBuilder buf = new StringBuilder();
           buf.append(s1);
           buf.append(s2);
           String s = buf.toString();

VB.NETの場合
           Dim s1 As String = "文字列１"
           Dim s2 As String = "文字列２"
          
           '2つの文字列を連結する
           Dim s3 As String = s1 & s2
           'Concatを使っても全く同じ
           Dim s4 As String = String.Concat(s1, s2)
          
           Dim sb As New System.Text.StringBuilder()
           sb.Append(s1)
           sb.Append(s2)
           Dim s5 As String = sb.ToString()

COBOLの場合

           01 TXTREC2  PIC X(600).
           01 WK-POINTER PIC 9(10).

           MOVE 1     TO WK-POINTER.  
           STRING
              "文字列１"  DELIMITED BY SIZE
              INTO  TXTREC2  WITH POINTER WK-POINTER
           END-STRING.
              "文字列２"  DELIMITED BY SIZE
              INTO  TXTREC2  WITH POINTER WK-POINTER
           END-STRING.
           STRING
              --------
           END-STRING.

ORACLEの場合
           CONCAT(文字列１ , 文字列２ )

SQL-Serverの場合
           文字列1 + 文字列2

PostgerSQLの場合
           '文字列1' || '文字列2'