# oracledb / knex.js 사용 방법

1. oracledb로 SQL 직접 사용하기

```ts
    // Oracle DB 연결 설정
    const connection = await oracledb.getConnection({
      user: process.env.ORACLE_USER,
      password: process.env.ORACLE_PASSWORD,
      connectString: process.env.ORACLE_CONNECTION_STRING
      
    });

    // 쿼리 수행
    const result = await connection.execute('SELECT 1 FROM DUAL');
    
    // 연결 종료
    await connection.close();
```

2. knex.js에서 SQL 직접 사용하기

```ts
export const oracleKnex = knex({
  client: 'oracledb',
  connection: {
    user: process.env.ORACLE_USER,
    password: process.env.ORACLE_PASSWORD,
    connectString: process.env.ORACLE_CONNECTION_STRING,
  },
  pool: { min: 0, max: 5 }
});

sql = 'SELECT 1 FROM DUAL;'
const result = await oracleKnex.raw(sql);
```

3. knex.js에서 쿼리빌더 사용하기
```ts
export const oracleKnex = knex({
  client: 'oracledb',
  connection: {
    user: process.env.ORACLE_USER,
    password: process.env.ORACLE_PASSWORD,
    connectString: process.env.ORACLE_CONNECTION_STRING,
  },
  pool: { min: 0, max: 5 }
});

const result = await knex
.qb
.select('column1', 'column2', 'column3')
.from('table_name')
```