Question

SQL语句中提示我缺少右括号

insert into department(department_id, department_name, location_id)values(seq_department.nextval, '教育部',(select location_id from location where city like '大连',rownum=1)); 提示我缺少右括号，能帮我看看吗?

Answer 1

values 前后空格,'大连' 后用 and ，不要用‘，’