我想插一条数据进一个表中,但某一个字段中的数据 来源于另外一个表,SQL 不对。不怎么 如何修改。 、 insert into "FINEXCHANGE"."FBI_RETRIEVAL_CONF" ( "ID",FINANCE_CHANNEL,QUERY_FINANCE_CHANNEL,QUERY_MODE,TIME_INTERVAL,STATUS_LIST,ENABLE_STATUS, "OPERATOR", GMT_CREATE, GMT_MODIFIED) VALUES(FBI_RETRIEVAL_CONF_SEQ.nextval, (select finance_channel from FBI_FINANCE_CHANNEL t where t.transaction_type='01' and t.FINANCE_SYSTEM_ID='UPOP' AND finance_channel='UPOPBOCSH_FBC02FB02FSS0401') as FINANCE_CHANNEL, (select finance_channel from FBI_FINANCE_CHANNEL t where t.transaction_type='07' and t.FINANCE_SYSTEM_ID='UPOP' and finance_channel='UPOPBOCSH_FBC02FB02FSS0407') as QUERY_FINANCE_CHANNEL,'1','5','1','1',SYSDATE,SYSDATE ) 帮我看看吧。麻烦 了。
update FBI_INFLUX_TRANSACTION set GMT_MODIFIED=(sysdate + 1/(24*60),'yyyy/mm/dd hh24:mi:ss') where SETTLE_STATUS='0'
但是不对。
sysdate指的是系统时间,你怎么拿系统时间+1分钟呢
我想把这个 做为一个条件来处理,但是 不行。
这个是示例 可以从dual 中是对的。
select sysdate,to_date('2009-2-20 17:45:39','yyyy-mm-dd hh24:mi:ss'),ROUND(TO_NUMBER(sysdate - to_date('2014-2-21 14:45:39','yyyy-mm-dd hh24:mi:ss')) * 24) from dual;
具体是 那有问题 还没有找出来
应该这样吧
to_date(to_char(GMT_CREATE,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')
、 insert into "FINEXCHANGE"."FBI_RETRIEVAL_CONF" ( "ID",FINANCE_CHANNEL,QUERY_FINANCE_CHANNEL,QUERY_MODE,TIME_INTERVAL,STATUS_LIST,ENABLE_STATUS,
"OPERATOR",
GMT_CREATE,
GMT_MODIFIED)
VALUES(FBI_RETRIEVAL_CONF_SEQ.nextval,
(select finance_channel from FBI_FINANCE_CHANNEL t where t.transaction_type='01' and t.FINANCE_SYSTEM_ID='UPOP' AND finance_channel='UPOPBOCSH_FBC02FB02FSS0401') as FINANCE_CHANNEL,
(select finance_channel from FBI_FINANCE_CHANNEL t where t.transaction_type='07' and t.FINANCE_SYSTEM_ID='UPOP' and finance_channel='UPOPBOCSH_FBC02FB02FSS0407') as QUERY_FINANCE_CHANNEL,'1','5','1','1',SYSDATE,SYSDATE )
帮我看看吧。麻烦 了。