목록Developers/OracleDB (3)

해나아부지 개발일지

OrcaleDB 11g sequence auto_increment 초기화 방법

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
Developers/OracleDB 2021. 2. 5. 09:39
nodejs + oracledb error handling ORA-00984 column not allowed here

클라이언트에서 전송하는 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] 이 발생한다.
Developers/OracleDB 2021. 2. 2. 16:59
오라클 11g id auto increment 적용하기

CREATE TABLE departments ( ID NUMBER(10) NOT NULL, DESCRIPTION VARCHAR2(50) NOT NULL); ALTER TABLE departments ADD ( CONSTRAINT dept_pk PRIMARY KEY (ID)); CREATE SEQUENCE dept_seq START WITH 1; 테이블 생성 후 PK를 지정해주고 시퀀스를 만들어 준다. CREATE OR REPLACE TRIGGER dept_bir BEFORE INSERT ON departments FOR EACH ROW BEGIN SELECT dept_seq.NEXTVAL INTO :new.id FROM dual; END; / 트리거도 만들어주면 끝! departments 테이블에 row..
Developers/OracleDB 2021. 2. 2. 16:40
Prev 1 Next