随笔分类 - DataBase
摘要：学习网站： https://www.runoob.com/mongodb/mongodb-tutorial.html https://www.mongodb.com/docs/ https://javaguide.cn/database/mongodb/mongodb-questions-01.ht
阅读全文
摘要：工具--显示首选项；Table--advanced;columns
阅读全文
摘要：以上两段代码都是VB脚本，在PowerDesigner中使用方法为： PowerDesigner->Tools->Execute Commands->Edit/Run Scripts 将代码Copy进去执行就可以了，是对整个CDM或PDM进行操作 Option Explicit Validation
阅读全文
摘要：--取表字段注释SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description FROM sys.tables A INNER JOIN sys.columns B ON B.object_id =
阅读全文
摘要：SELECT OBJECT_NAME(i.object_id) AS objectName, i.name AS indexName, SUM(a.total_pages) AS totalPages, SUM(a.used_pages) AS usedPages, SUM(a.data_pages
阅读全文
摘要：SELECT ROW_NUMBER () OVER ( PARTITION BY REG_NO,MZ_FLAG,BL_TYPE ORDER BY BL_ORDER,BL_TIME ) CNO,BL_ORDNO,REG_NO,MZ_FLAG,BL_TYPE,BL_ORDER FROM EMR_PATI
阅读全文
摘要：解决中文乱码问题，导致查询出现问题 set names utf8
阅读全文
摘要：变量名 ORACLE_HOME 变量值 G:\app\TH\product\11.2.0\dbhome_1 （这个地方输入你的安装地址，我输的是我的路径） （2） 变量名 TNS_ADMIN 变量值 G:\app\TH\product\11.2.0\dbhome_1\NETWORK\ADMIN （3
阅读全文
摘要：create user wtuser identified by wtuser / grant connect,resource to xtuser drop public synonym V_XT_INTF_DEPT / drop public synonym V_XT_INTF_WARD / d
阅读全文
摘要：更新root账户的权限。打开mysql命令行窗口，输入 grant all privileges on *.* to root@"%" identified by 'abc' with grant option; flush privileges; 上述语句的完整模板为： grant all pri
阅读全文
摘要：Ora 字符串转集合，集合转字符串，转char， select CL_EDIAG,(SELECT DIAG_NAME FROM CODE_DIAGNOSE WHERE DIAG_CODE =CL_EDIAG ) CL_EDIAGNAME, CL_CDIAG CL_CDIAGNAME,dbms_lob
阅读全文
摘要：Agent process exited abnormally during initialization.
阅读全文
