Oracle's SQL statement uses

1.Oracle string concatenation

Oracle supports string concatenation with the concat () function and automatically converts other types to strings except for "| |", but unlike MySQL's concat () function, Oracle's CONCAT () function supports only two parameter stitching. If more than one parameter needs to be nested using multiple CONCAT () functions, as shown in the following sql: SELECT CONCAT (CONCAT (' Work number is ', ' fnumber '), ' Employee Name '), FName) from T_employee WHERE FName is not NULL;

Oracle's SQL statement uses