해나아부지 개발일지

SQL> SELECT LAST_NUMBER FROM USER_SEQUENCES WHERE SEQUENCE_NAME = '시퀀스명'; NEXTVAL ------- 13 SQL> alter sequence 시퀀스명 increment by -13 minvalue 0; Sequence altered. SQL> select s.nextval from dual; NEXTVAL ---------- 0 SQL> alter sequence s increment by 1; Sequence altered. SQL> select s.nextval from dual; NEXTVAL ---------- 1

클라이언트에서 전송하는 req.body string을 SQL 쿼리에 넣기 위해서 `` (백틱) 사용시 (req, res) => { const { a, b, c } = req.body; oracleDb.getConnection({ user: 'user', password: 'password', connectString: 'localhost/XE' }, (err, connection) => { let result = connection.execute( `insert into main values (${a}, ${b}, ${c})` ) console.log(result) }) } [Error: ORA-00984: column not allowed here] 이 발생한다.