求助一個(gè)update語句

qinghan1125

如下生成的update語句HIREDATE后的日期沒有帶引號(hào)，請(qǐng)問如何在我寫的select語句中將1980-12-1加上引號(hào)呢？用\也不行

SQL>  select 'update emp set HIREDATE=1980-12-1 where empno='|| empno from emp;

'UPDATEEMPSETHIREDATE=1980-12-
--------------------------------------------------------------------------------
update emp set HIREDATE=1980-12-1 where empno=7369
update emp set HIREDATE=1980-12-1 where empno=7499
update emp set HIREDATE=1980-12-1 where empno=7521
update emp set HIREDATE=1980-12-1 where empno=7566
update emp set HIREDATE=1980-12-1 where empno=7654
update emp set HIREDATE=1980-12-1 where empno=7698
update emp set HIREDATE=1980-12-1 where empno=7782
update emp set HIREDATE=1980-12-1 where empno=7788
update emp set HIREDATE=1980-12-1 where empno=7839
update emp set HIREDATE=1980-12-1 where empno=7844
update emp set HIREDATE=1980-12-1 where empno=7876
update emp set HIREDATE=1980-12-1 where empno=7900
update emp set HIREDATE=1980-12-1 where empno=7902
update emp set HIREDATE=1980-12-1 where empno=7934

doni

select 'update emp set HIREDATE=''1980-12-1'' where empno='|| empno from emp;

doni

select 'update emp set HIREDATE= '||chr(39)||'1980-12-1'||char(39)||' where empno='|| empno from emp;

qinghan1125

感謝，3樓正解，呵呵

gguxxing008

select 'update emp set HIREDATE=' || '1980-12-1' || 'where empno=' || empno from emp;

renxiao2003

兩個(gè)引號(hào)。

gguxxing008

回復(fù) 6# renxiao2003


呵呵  是的 兩個(gè)引號(hào)表示一個(gè)單引號(hào)，當(dāng)時(shí)知道這個(gè)錯(cuò)誤后來沒找到這個(gè)貼就沒改~~

renxiao2003

回復(fù) 7# gguxxing008


    呵呵。這就是SQL的轉(zhuǎn)義。

moon38sun

不用連接符也可以吧
select 'update emp set HIREDATE=' '1980-12-1' 'where empno=' empno from emp;