ora-00936,缺少表达式

发布网友发布时间：2022-04-30 01:06

共1个回答

热心网友时间：2022-04-13 17:49

你错在这个地方，不能这么用

SELECT t.task_id FROM efs_grown_task_activity t WHERE

t.task_class = '1' AND t.task_name = '测试一下'

你这种情况需要这样

insert into EFS_GROWN_TASK_ACTIVITY
  (TASK_ID,
   TASK_CLASS,
   RELATION_TASK_ID,
   TASK_TYPE,
   TASK_DETAIL_TYPE_KEY,
   TASK_NAME,
   TASK_DESC,
   START_TIME,
   END_TIME,
   SHOW_ITEM,
   TASK_IMG,
   HANDEL_CLASS,
   CALLBACK_FUN,
   IS_SHOW,
   TIMES,
   TIME_RATE,
   TASK_COINS,
   OTHER_CONDITIONS)
  SELECT to_char(sysdate, 'yyyy') ||
         lpad(efsdata.SEQ_EFS_GROWN_TASK_ACTIVITY_ID.nextval, 16, 0),
         '2',
         t.task_id,
         '01',
         '',
         'aaaaa',
         'bbbbbbbbbb',
         to_date('2014-12-17', 'yyyy-mm-dd'),
         to_date('2015-12-17', 'yyyy-mm-dd'),
         3,
         '',
         'dadsfsdfsdafsdafds',
         '',
         'Y',
         0,
         '0',
         100,
         ''
    FROM efs_grown_task_activity t
   WHERE t.task_class = '1'
     AND t.task_name = '测试一下'