10 2024 档案
摘要:ps # 指定源目录和输出文件路径 $projectName = "xxx" $sourceDirectory = "C:\Projects\" + $projectName $outputFile = "C:\Output\" + $projectName + ".txt" # 确保输出目录存在
阅读全文
摘要:返回一个值 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
阅读全文
摘要:使用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
阅读全文