oracle insert문 에러입니다 ㅜㅜ

Question

create table member(member_id number primary key,user_id varchar2(50),name varchar2(50),password varchar2(50),email_id varchar2(50),email_server varchar2(50),addr varchar2(150),phone varchar2(50),regdate date default sysdate); create sequence seq_memberincrement by 1start with 1; 값을 이렇게 넣었고 insert into &#34;MEMBER&#34; (MEMBER_ID, USER_ID,NAME,PASSWORD,EMAIL_ID,EMAIL_SERVER,PHONE,ADDR) values(seq_member.nextval,'test','홍길동','test','test','gmail.com','01000000000''test'); SQL Error [947] [42000]: ORA-00947: not enough values 오류가 뜹니다. 충분히 다 채워넣은거 같은데 어디가 문제일까요?

브로콜리먹기 · Answer

values(seq_member.nextval,'test','홍길동','test','test','gmail.com','01000000000''test');마지막에 콤마가 없네요

oracle insert문 에러입니다 ㅜㅜ

1개의 답변

#oracle11g 목록