From 9bce48a9f30f7d80c43f43f46d40df20fcb00e15 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 03 二月 2023 09:39:59 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 3ab4283..bc52b34 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -289,6 +289,22 @@
select fn_rec_query(depid,'dep') depName,fn_rec_query(dirid,'dir') dirName,fn_ver(verid) verName,fn_uname(createuser) createName,fn_uname(updateuser) updateName from bd.dlg_agnp limit 5;
select ns,tab from lf.sys_dict a where not exists (select id from lf.sys_dict b where b.ns=a.ns and b.tab=a.tab and b.field='gid') group by ns,tab; -- 鏌ヨ瀛楀吀涓笉瀛樺湪gid鐨勮〃
+----------------------------------------------------------------------------------------------
+-- 10杩涘埗杞�62杩涘埗
+WITH RECURSIVE T(N, S) AS (
+ SELECT 3843::NUMERIC(30, 0) N, '' S
+ UNION ALL
+ SELECT trunc(N / 62)::NUMERIC(30, 0), substr('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz', (N % 62)::INT + 1, 1) || S FROM T WHERE N > 0
+)
+SELECT S FROM T WHERE N = 0;
+
+-- 62杩涘埗杞�10杩涘埗
+WITH RECURSIVE T(S, N) AS (
+ SELECT 'ZZ' S, 0::NUMERIC N
+ UNION ALL
+ SELECT SUBSTR(S, 2), (POWER(62, LENGTH(S)::NUMERIC - 1) * (strpos('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz', SUBSTR(S, 1, 1)) - 1) + N) FROM T WHERE LENGTH(S) > 0
+)
+SELECT N::NUMERIC(30, 0) FROM T WHERE LENGTH(S) < 1;
---------------------------------------------------------------------------------------------- -1.娴嬭瘯
select id,name from lf.sys_dir where name in ('娴嬮噺锛圗SV锛�','鍕樺療锛圗GE锛�','鍦扮伨锛圗GD锛�','娲炲簱锛圗GD锛�') order by name;
--
Gitblit v1.9.3