oracle: 字符串拼接的写法

最新推荐文章于 2021-12-27 18:54:12 发布

30baby

最新推荐文章于 2021-12-27 18:54:12 发布

阅读量363

点赞数

分类专栏： ORACLE

本文链接：https://blog.csdn.net/ibsfn/article/details/88424570

版权

ORACLE 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

根据emp表拼出

select ename,job,sal,hiredate from emp where hiredate=to_date('1980/12/17','yyyy/mm/dd');

语句如下

SQL> select 'select ename,job,sal,hiredate from emp where hiredate=to_date('''||to_char(hiredate,'yyyy/mm/dd')||''',''yyyy/mm/dd'');' from emp;

'SELECTENAME,JOB,SAL,HIREDATEFROMEMPWHEREHIREDATE=TO_DATE('''||TO_CHAR(HIREDATE,'YYYY/MM/
-----------------------------------------------------------------------------------------
select ename,job,sal,hiredate from emp where hiredate=to_date('1980/12/17','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/02/20','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/02/22','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/04/02','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/09/28','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/05/01','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/06/09','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1982/12/09','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/11/17','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/09/08','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1983/01/12','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/12/03','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1981/12/03','yyyy/mm/dd');
select ename,job,sal,hiredate from emp where hiredate=to_date('1982/01/23','yyyy/mm/dd');

14 rows selected.