字符函数是单行函数的一种
select ASCII('a'),ASCII('A'),ASCII('z'),ASCII('Z'),ASCII(0),ASCII(9) from dual
ASCII('a'), ASCII('A') ASCII('z'), ASCII('Z'), ASCII(0), ASCII(9)
97 65, 122, 90, 48, 57
ASCII(), 返回字符x的ASCII码
dual 这个表可以用来执行不对任何特定表进行操作的查询。
select concat(empno,ename) from emp
7369SMITH
7499ALLEN
select ASCII('a'),ASCII('A'),ASCII('z'),ASCII('Z'),ASCII(0),ASCII(9) from dual
ASCII('a'), ASCII('A') ASCII('z'), ASCII('Z'), ASCII(0), ASCII(9)
97 65, 122, 90, 48, 57
ASCII(), 返回字符x的ASCII码
dual 这个表可以用来执行不对任何特定表进行操作的查询。
select concat(empno,ename) from emp
7369SMITH
7499ALLEN