一个insert说我缺少表达式

乾K大挪移 2010-03-24 05:30:22



insert into MET_COM_ICD9 c

  (c.sequence_no,

   c.icd_code,

   c.icd_name,

   c.oper_code,

   c.oper_date)

values

  (select TICD.Nextval as sequence_no,

          TICD.CURRVAL as icd_code,

          t.groupname,

          '662' as oper_code,

          sysdate as oper_date

     from com_text t)

说我缺少表达式？我错在哪里？ TICD 是一个序列
我单独执行



select TICD.Nextval as sequence_no,

          TICD.CURRVAL as icd_code,

          t.groupname,

          '662' as oper_code,

          sysdate as oper_date

     from com_text t

是可以的

...全文

410 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

乾K大挪移 2010-03-25

打赏
举报

应该吧values去掉，知道了

烈火蜓蜻 2010-03-24

打赏
举报

改成这样就可以了



insert into MET_COM_ICD9

  (c.sequence_no,

   c.icd_code,

   c.icd_name,

   c.oper_code,

   c.oper_date)

select TICD.Nextval as sequence_no,

          TICD.CURRVAL as icd_code,

          t.groupname,

          '662' as oper_code,

          sysdate as oper_date

     from com_text t

表名MET_COM_ICD9后多了一个 c

如果是多条插入的话，不能加 values关键字

「已注销」 2010-03-24

打赏
举报

[Quote=引用 5 楼 sql77 的回复:]
SQL code
insert into MET_COM_ICD9 c
(c.sequence_no,
c.icd_code,
c.icd_name,
c.oper_code,
c.oper_date)

select TICD.Nextval as sequence_no,
TICD.CURRVAL as icd_code,
……
[/Quote]
o了

liuchuan_beijing 2010-03-24

打赏
举报

up一下77

mayonglong 2010-03-24

打赏
举报

深海之蓝 2010-03-24

打赏
举报

[Quote=引用 6 楼 wuyq11 的回复:]
insert into MET_COM_ICD9 c(c.sequence_no,c.icd_code,c.icd_name,c.oper_code,c.oper_date)
select TICD.Nextval as sequence_no,
TICD.CURRVAL as icd_code,
t.groupname,
'662' as oper_code,
sysdate as o……
[/Quote]
恩

zyjj521 2010-03-24

打赏
举报

wuyq11 2010-03-24

打赏
举报

insert into MET_COM_ICD9 c(c.sequence_no,c.icd_code,c.icd_name,c.oper_code,c.oper_date)
select TICD.Nextval as sequence_no,
TICD.CURRVAL as icd_code,
t.groupname,
'662' as oper_code,
sysdate as oper_date
from com_text t

SQL77 2010-03-24

打赏
举报

insert into MET_COM_ICD9 c

  (c.sequence_no,

   c.icd_code,

   c.icd_name,

   c.oper_code,

   c.oper_date)



  select TICD.Nextval as sequence_no,

          TICD.CURRVAL as icd_code,

          t.groupname,

          '662' as oper_code,

          sysdate as oper_date

     from com_text T

还有VALUES没去掉,晕

SQL77 2010-03-24

打赏
举报

insert into MET_COM_ICD9 c

  (c.sequence_no,

   c.icd_code,

   c.icd_name,

   c.oper_code,

   c.oper_date)

values

  select TICD.Nextval as sequence_no,

          TICD.CURRVAL as icd_code,

          t.groupname,

          '662' as oper_code,

          sysdate as oper_date

     from com_text T



不用加括号了

狂想者 2010-03-24

打赏
举报

应该是格式写错了，楼上的挺好！

波导终结者 2010-03-24

打赏
举报

insert into MET_COM_ICD9 c (c.sequence_no, c.icd_code, c.icd_name, c.oper_code, c.oper_date) select TICD.Nextval as sequence_no, TICD.CURRVAL as icd_code, t.groupname, '662' as oper_code, sysdate as oper_date from com_text t

liuyileneal 2010-03-24

打赏
举报



insert into MET_COM_ICD9 c

  (c.sequence_no,

   c.icd_code,

   c.icd_name,

   c.oper_code,

   c.oper_date)

as (select TICD.Nextval as sequence_no,

          TICD.CURRVAL as icd_code,

          t.groupname,

          '662' as oper_code,

          sysdate as oper_date

     from com_text t)