Attachment 21965 Details for Bug 44998 – Output from sample java code

Output from sample java code

HSLF-test.txt (text/plain), 3.30 KB, created by Yegor Kozlov on 2008-05-14 23:11:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Yegor Kozlov

Created: 2008-05-14 23:11:25 UTC

Size: 3.30 KB

patch

obsolete

>slide: 1
>  SQL Tips - String Concatenation
>  Robert Froehling  robert.froehling@gmail.com
>slide: 2
>  Concatenation Methods
>  MSSQL
>	string1 + string2
>
>MySQL
>	CONCAT(string1,string2,...)?
>	CONCAT_WS( ,string1,string2,...)?
>
>Oracle
>	CONCAT(string1,string2)?
>	string1 || string2
>slide: 3
>  What Do We Have?
>  EMPID
>  FNAME
>  MNAME
>  LNAME
>  1
>  John
>  Andrew
>  Doe
>  2
>  Jim
>  Bob
>  Brown
>  3
>  Bill
>  NULL
>  Smith
>slide: 4
>  What Do We Want?
>  FirstName LastName
>FirstName MiddleName LastName
>FirstName MiddleInitial LastName
>FirstInitial LastName
>LastName, FirstName
>slide: 5
>  FirstName LastName
>  MSSQL
>SELECT fname +   + lname AS fullname
>FROM employee
>
>MySQL
>SELECT CONCAT_WS( ,fname,lname) AS fullname
>FROM employee
>
>Oracle
>SELECT fname ||   || lname AS fullname
>FROM employee
>
>slide: 6
>  FirstName MiddleName LastName
>  MSSQL
>SELECT
>	fname +   + mname +   + lname AS fullname
>
>MySQL
>SELECT
>	CONCAT_WS( ,fname,mname,lname) AS fullname
>
>Oracle
>SELECT
>	fname ||   || mname ||   || lname AS fullname
>
>slide: 7
>  FirstName MiddleName LastName
>  MSSQL  NULL Result
>SELECT
>	fname +   + mname +   + lname AS fullname
>
>MSSQL  Proper Result
>SELECT
>	fname + ISNULL((  + mname +  ), ) + lname AS fullname
>slide: 8
>  FirstName MiddleName LastName
>  Oracle  Extra Space
>SELECT
>	fname ||   || mname ||   || lname AS fullname
>
>Oracle  Proper Result
>SELECT
>	fname || NVL2(mname,(  || mname ||  ), ) || lname AS fullname
>
>slide: 9
>  FirstName MiddleInitial LastName
>  MSSQL
>SELECT
>	fname + ISNULL((  + LEFT(mname,1) +  ),) + lname AS fullname
>
>MySQL
>SELECT
>	CONCAT_WS( ,fname,SUBSTRING(mname FROM 1 FOR 1),lname) AS fullname
>
>Oracle
>SELECT
>	 fname || NVL2(mname,(  || SUBSTR(mname,1,1) ||
>	  ), ) || lname AS fullname
>
>slide: 10
>  FirstInitial LastName
>  MSSQL
>SELECT
>	LEFT(fname,1) +   + lname AS fullname
>
>MySQL
>SELECT
>	CONCAT_WS( ,SUBSTRING(fname FROM 1 FOR 1),lname) AS fullname
>
>Oracle
>SELECT
>	SUBSTR(fname,1,1) ||   || lname AS fullname
>
>slide: 11
>  LastName, FirstName
>  MSSQL
>SELECT lname + ,  + fname AS fullname
>
>MySQL
>SELECT CONCAT_WS(, ,lname,fname) AS fullname
>
>Oracle
>SELECT lname || ,  || fname AS fullname
>
>slide: 12
>  UDF
>  SELECT UDF_FULLNAME(fname,mname,lname) AS fullname
>FROM employee
>slide: 13
>  UDF - MSSQL
>  CREATE FUNCTION UDF_FULLNAME (
>	@nfname VARCHAR(25),
>	@nmname VARCHAR(25),
>	@nlname VARCHAR(25)?
>)?
>RETURNS VARCHAR(100)?
>BEGIN
>	DECLARE @result VARCHAR(100)?
>	SET @result = @nfname + ISNULL((  + LEFT(@nmname,1) +  ),) + @nlname
>	RETURN @result
>END
>slide: 14
>  UDF - MySQL
>  CREATE FUNCTION UDF_FULLNAME (
>	nfname VARCHAR(25),
>	nmname VARCHAR(25),
>	nlname VARCHAR(25)?
>)?
>RETURNS VARCHAR2(100)?
>BEGIN
>	DECLARE result VARCHAR(100) DEFAULT NULL;
>	SET result = CONCAT_WS( ,nfname,SUBSTRING(nmname FROM 1 FOR 1),nlname);
>	RETURN result;
>END UDF_FULLNAME;
>
>slide: 15
>  UDF - Oracle
>  CREATE FUNCTION UDF_FULLNAME (
>	nfname IN VARCHAR2(25),
>	nmname IN VARCHAR2(25),
>	nlname IN VARCHAR2(25)?
>)?
>RETURNS VARCHAR2(100)?
>IS
>	result VARCHAR2(100) DEFAULT NULL;
>BEGIN
>	result := nfname || NVL2(nmname,(  || SUBSTR(nmname,1,1) ||  ), ) || nlname;
>	RETURN result;
>END UDF_FULLNAME;
>

Actions: View

Attachments on bug 44998: 21961 | 21964 | 21965