摘要: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 监听器目前不知道在连接描述符中的服务请求。 Expert Oracle Database Tips by Donald 阅读全文
posted @ 2017-11-25 01:00 杨杨yang 阅读(426) 评论(0) 推荐(0) 编辑
摘要: reference to wbsite:http://zhangzhongjie.iteye.com/blog/1948930#comments DBMS_RANDON PACKAGE: Define; It is procedure package that can generate randon 阅读全文
posted @ 2017-11-18 15:22 杨杨yang 阅读(131) 评论(0) 推荐(0) 编辑
摘要: How to import .sql script 1.Export .sql from pl/sql developer you can reference to other document in my blog. 2.use @ symbol import write .sql script 阅读全文
posted @ 2017-11-18 00:30 杨杨yang 阅读(193) 评论(0) 推荐(0) 编辑
摘要: MEGE Sentence This oracle tutorial explains how to use the oralce MEGER sentence with syntax and samples. Description The MEGE sentence aim to reduce 阅读全文
posted @ 2017-11-16 21:23 杨杨yang 阅读(202) 评论(0) 推荐(0) 编辑
摘要: question:How to alter department in PMS system 1.Use generally method modified department; update emp set deptno='department code' where empno='employ 阅读全文
posted @ 2017-11-16 20:02 杨杨yang 阅读(111) 评论(0) 推荐(0) 编辑
摘要: First, please use System File Checker tool to troubleshoot(诊断) this issue. If the issue persists, import the following registry key and see if the iss 阅读全文
posted @ 2017-11-14 19:52 杨杨yang 阅读(357) 评论(0) 推荐(0) 编辑
摘要: QUESTION:When you meet calculate fraction in oracle SOLUTION: 1.Check out their values respectively. the use sign of division. select count(1) from em 阅读全文
posted @ 2017-11-13 21:36 杨杨yang 阅读(191) 评论(0) 推荐(0) 编辑
摘要: Long Wei information technology development Limited by Share Ltd interview summary. I take part in company interveiw in November 13.2017.Get up in the 阅读全文
posted @ 2017-11-13 20:11 杨杨yang 阅读(142) 评论(0) 推荐(0) 编辑
摘要: ORACLE BACKUP AND RECOVERY http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/backup/backup.htm 阅读全文
posted @ 2017-11-12 15:00 杨杨yang 阅读(139) 评论(0) 推荐(0) 编辑
摘要: DESCRIBE:When you mouse click right-side is open an application and click left-side is attribution. solution:you can following below step operator 阅读全文
posted @ 2017-11-11 16:07 杨杨yang 阅读(95) 评论(0) 推荐(0) 编辑