SELECT employee_id FROM employee where employee_name='SMITH';
输出为76123
如何在Oracle中编写查询以打印输出,如下所示
'%76123%'
使用串联是一种选择。
SQL> select chr(39) || '%' || empno || '%' ||chr(39) as result
2 from emp
3 where rownum = 1;
RESULT
--------------------------------------------
'%7369%'
SQL>
chr(39)
是一个单引号(使用它比重复几个单引号更简单(:
SQL> select '''%' || empno || '%''' as result
2 from emp
3 where rownum = 1;
RESULT
--------------------------------------------
'%7369%'
SQL>