我要把 “select to_char(sysdate-1,'YYYYMMDD') from dual”插入数据库中,这么弄啊,
我用下面语句:
insert into table values('select to_char(sysdate-1,'YYYYMMDD') from dual')
结果单引号把'select to_char(sysdate-1,'当作一个字符串了,
求给位大侠帮帮忙!
我用下面语句:
insert into table values('select to_char(sysdate-1,'YYYYMMDD') from dual')
结果单引号把'select to_char(sysdate-1,'当作一个字符串了,
求给位大侠帮帮忙!
改为declare @date varchar(10)
@date =select to_char(sysdate-1,'YYYYMMDD') from dual
insert into table values(@date )
insert into test values('select to_char(sysdate-1,'YYYYMMDD') from dual')
*
第 1 行出现错误:
ORA-00917: 缺失逗号
OPER@tl>insert into test values('select to_char(sysdate-1,''YYYYMMDD'') from dual');已创建 1 行。OPER@tl>select * from test;AAA
--------------------------------------------------
select to_char(sysdate-1,'YYYYMMDD') from dualOPER@tl>