From a72fa8038f57c9765089a0a0e6003c428be91811 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期一, 07 三月 2022 13:05:14 +0800
Subject: [PATCH] fix 修复oracle时间查询相关问题
---
script/sql/oracle/oracle_ry_vue_4.X.sql | 13 +++++++++++++
script/docker/database.yml | 2 ++
2 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/script/docker/database.yml b/script/docker/database.yml
index e7c276f..36fb576 100644
--- a/script/docker/database.yml
+++ b/script/docker/database.yml
@@ -1,6 +1,8 @@
version: '3'
services:
+ # 姝ら暅鍍忎粎鐢ㄤ簬娴嬭瘯 姝ｅ紡鐜闇�鑷瀹夎鏁版嵁搴�
+ # SID: XE user: system password: oracle
oracle:
image: tekintian/oracle12c:latest
container_name: oracle
diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index c13f5ac..5342d14 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -952,3 +952,16 @@
select instr(','||arg2||',' , ','||arg1||',') into Result from dual;
return(Result);
end find_in_set;
+
+/ -- 鍑芥暟鍒嗛殧绗�
+
+-- ----------------------------
+-- 閽╁瓙 锛岀敤浜巗ession杩炴帴涔嬪悗 鑷姩璁剧疆榛樿鐨刣ate绫诲瀷鏍煎紡鍖� 绠�鍖栨椂闂存煡璇�
+-- 濡傞渶璁剧疆鍏跺畠閰嶇疆 鍙湪姝ら挬瀛愬唴浠绘剰澧炲姞澶勭悊璇彞
+-- 渚嬪锛� SELECT * FROM sys_user WHERE create_time BETWEEN '2022-03-01 00:00:00' AND '2022-04-01 00:00:00'
+-- ----------------------------
+create or replace trigger login_trg
+after logon on database
+begin
+execute immediate 'alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''';
+end login_trg;
--
Gitblit v1.9.3