From 8a89054c2f1dfa06c6dfc744217b35e66b8a3661 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 09 三月 2022 16:21:53 +0800
Subject: [PATCH] add 增加 oracle_test.sql 测试sql文件
---
script/sql/oracle/oracle_ry_vue_4.X.sql | 18 ++++++++++++++++--
1 files changed, 16 insertions(+), 2 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index c13f5ac..6295231 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -57,8 +57,8 @@
create table sys_user (
user_id number(20) not null,
dept_id number(20) default null,
- user_name varchar2(30) not null,
- nick_name varchar2(30) not null,
+ user_name varchar2(40) not null,
+ nick_name varchar2(40) not null,
user_type varchar2(10) default 'sys_user',
email varchar2(50) default '',
phonenumber varchar2(11) default '',
@@ -952,3 +952,17 @@
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;
--
Gitblit v1.9.3