SQL_rpad_concat1

This is a document Template

SQL_rpad_concat1

Oracle concat function:

SELECT empno,concat (rpad(ename, 10,'.' ), deptno)"name-dept" from emp where rownum < 7

PostgreSQL

SELECT empno,concat (rpad(ename, 10,'.' ), deptno)"name-dept" from emp limit 7

MySQL

SELECT empno,concat (rpad(ename, 10,'.' ), deptno)"name-dept" from emp limit 7

row : 2

Oracle:

PostgreSQL

MySQL