随笔分类 -  达梦

摘要:SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' DATETIME;' AS alter_sql FROM ALL_TAB_COLUMNS WHERE DATA_TYPE = ' 阅读全文
posted @ 2025-09-25 13:38 三瑞 阅读(51) 评论(0) 推荐(0)
摘要:select a.*,b.NAME,b.*,c.SESS_ID from v$lock a left join sysobjects b on b.ID=a.TABLE_ID left join v$sessions c on a.TRX_ID=c.TRX_ID where b.NAME = 'DP 阅读全文
posted @ 2025-06-25 15:26 三瑞 阅读(27) 评论(0) 推荐(0)
摘要:GRANT SELECT ON 模式.表名 TO SYSDBA; BEGIN FOR rec IN (SELECT table_name FROM all_tables WHERE owner = '模式') LOOP EXECUTE IMMEDIATE 'GRANT SELECT ON 模式.' 阅读全文
posted @ 2025-06-05 10:15 三瑞 阅读(101) 评论(0) 推荐(0)
摘要:下载地址: https://www.dameng.com/list_103.html 选择cpu和操作系统 下载前要登录,你就登录一下就可以了。 下载的文件为:dotnet-sdk-3.1.426-win-x86.zip 解析后现将dm8_20250122_x86_win_64.iso解压,运行Se 阅读全文
posted @ 2025-02-28 16:18 三瑞 阅读(261) 评论(0) 推荐(0)