oracle insert into 报缺失表达式的错误

insert into dbo.userinfo@test ("Badgenumber","SSN") (select userid,userid from hr_to_attendance f where f.update_date = (select to_char(sysdate-1,'yyyy-mm-dd') from dual) and f.operation_state = 'I'); 把values去掉就可以了