10 2024 档案

摘要:ps # 指定源目录和输出文件路径 $projectName = "xxx" $sourceDirectory = "C:\Projects\" + $projectName $outputFile = "C:\Output\" + $projectName + ".txt" # 确保输出目录存在 阅读全文
posted @ 2024-10-24 16:49 Robot-Blog 阅读(98) 评论(0) 推荐(0) 编辑
摘要:返回一个值 create or replace FUNCTION GET_KEY_BY_QUERY ( AAA IN VARCHAR2 ) RETURN NUMBER IS ITEM_VALUE NUMBER; BEGIN SELECT 'TEST' INTO ITEM_VALUE FROM DUA 阅读全文
posted @ 2024-10-21 16:56 Robot-Blog 阅读(47) 评论(0) 推荐(0) 编辑
摘要:使用REGEXP_SUBSTR SELECT REGEXP_SUBSTR(key, '[^,]+', 1, ROWNUM) AS VALUE FROM ( select '1,3,4,4' as key from dual ) CONNECT BY ROWNUM <= LENGTH(key) - L 阅读全文
posted @ 2024-10-21 16:48 Robot-Blog 阅读(190) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示