From 11061af33d325546e075b37923845881ded0e6f6 Mon Sep 17 00:00:00 2001
From: dujinkim <dujin.kim@dtsolution.co.kr>
Date: Wed, 21 May 2025 10:04:19 +0000
Subject: (김준회) Oracle DB 지원을 위한 라이브러리(oracledb, knex.js) 추가 및
 번들러 버그 패치
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 lib/oracle-knex/README.md | 54 +++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 54 insertions(+)
 create mode 100644 lib/oracle-knex/README.md

(limited to 'lib/oracle-knex/README.md')

diff --git a/lib/oracle-knex/README.md b/lib/oracle-knex/README.md
new file mode 100644
index 00000000..fdff6e2f
--- /dev/null
+++ b/lib/oracle-knex/README.md
@@ -0,0 +1,54 @@
+# 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')
+```
\ No newline at end of file
-- 
cgit v1.2.3