oracle: 字符串拼接的写法

最新推荐文章于 2022-06-16 23:29:39 发布

原创最新推荐文章于 2022-06-16 23:29:39 发布 · 405 阅读

0 ·

CC 4.0 BY-SA版权

ORACLE 专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一种使用SQL语句从数据库中筛选特定日期记录的方法。通过动态构建SQL查询语句，可以灵活地针对不同的日期进行数据检索。示例展示了如何在emp表中查找1980至1983年间特定日期雇佣的员工信息，包括姓名、职位、薪资及雇佣日期。

根据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.