yjhsbn
随笔 - 61,  文章 - 0,  评论 - 0,  阅读 - 23469
11 2017 档案
Compare DML To Both REDO And UNDO Size
摘要：SUMMARY you can remember undo rule the same to redo if you want demo rule that you can look up the follow link http://blog.csdn.net/haibusuanyun/artic 阅读全文
posted @ 2017-11-30 00:31 杨杨yang 阅读(120) 评论(0) 推荐(0) 编辑
recycle bin tip
摘要：if you have a question about recycle bin that can look the follow link; http://www.dba-oracle.com/t_oracle_recycle_bin.htm 阅读全文
posted @ 2017-11-28 23:41 杨杨yang 阅读(135) 评论(0) 推荐(0) 编辑
INSERT CLAUSE
摘要：a.single table insert b.more table insert 阅读全文
posted @ 2017-11-27 21:35 杨杨yang 阅读(141) 评论(0) 推荐(0) 编辑
how to drop multiple talbes in oracle use a sigle query
摘要：Tool:PL/SQL developer Syntax:SELECT 'DROP TABLE ' || table_name || ';' FROM user_tables; 1.then you can copy select result in command widows. 2.you ca 阅读全文
posted @ 2017-11-25 09:56 杨杨yang 阅读(134) 评论(0) 推荐(0) 编辑
ORA-12514
摘要：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 阅读(443) 评论(0) 推荐(0) 编辑
dbms_randon package
摘要：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 阅读(133) 评论(0) 推荐(0) 编辑
How to import .sql script
摘要：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 阅读(195) 评论(0) 推荐(0) 编辑
MEGER sentence in oracle
摘要：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 阅读(205) 评论(0) 推荐(0) 编辑
How to alter department in PMS system
摘要：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 阅读(115) 评论(0) 推荐(0) 编辑
Can't create new folder in windows7
摘要：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 阅读(364) 评论(0) 推荐(0) 编辑
calculate fraction by oracle
摘要：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 阅读(196) 评论(0) 推荐(0) 编辑
Long Wei information technology development Limited by Share Ltd interview summary.
摘要：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 阅读(161) 评论(0) 推荐(0) 编辑
ORACLE BACKUP AND RECOVERY
摘要：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 阅读(141) 评论(0) 推荐(0) 编辑
DESCRIBE:When you mouse click right-side is open an application and click left-side is attribution.
摘要：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 阅读(99) 评论(0) 推荐(0) 编辑
ORACLE_TO_CHAR Function
摘要：TECHONTHENNTE WEBSITE: https://www.techonthenet.com/oracle/functions/to_char.php Oracle / PLSQL: TO_CHAR Function This Oracle tutorial explains how to 阅读全文
posted @ 2017-11-11 14:45 杨杨yang 阅读(175) 评论(0) 推荐(0) 编辑
My personal website:http://47.94.240.229:8080/yjh/project/
摘要：My personal website: http://47.94.240.229:8080/yjh/project/ 阅读全文
posted @ 2017-11-10 22:00 杨杨yang 阅读(270) 评论(0) 推荐(0) 编辑
How to reference two table when lack reference column.
摘要：Question:How to reference two table when lack reference column. Example: 1.Create two tables the one of lack reference column. 2.add a column become a 阅读全文
posted @ 2017-11-08 22:24 杨杨yang 阅读(149) 评论(0) 推荐(0) 编辑
how find a record import other database.
摘要：question:how find a record import other database. answer: solution one:you user insert into table_name values(value1,value2,...) solution two(recommen 阅读全文
posted @ 2017-11-08 00:14 杨杨yang 阅读(186) 评论(0) 推荐(0) 编辑
when create a table,then show error ora-00952 tablespace tsb_1 not exist
摘要：QUESTION:When create a table,then show error ora-00952 tablespace tsb_1 not exist. STEP: 1.select user table tablespace. SELECT username,DEFAULT_TABLE 阅读全文
posted @ 2017-11-07 20:34 杨杨yang 阅读(213) 评论(0) 推荐(0) 编辑
TELNET_COMMAND
摘要：TELENT COMMAND DEFINE:Telnet is a command control your cmd windows of remote computer. step: 1.Open you server in the two computer each oter communica 阅读全文
posted @ 2017-11-06 22:18 杨杨yang 阅读(325) 评论(0) 推荐(0) 编辑
ORACLE_SPOOL
摘要：Question:When you use developer tool in oracle.However,you press Ctrl and click left-mouse in a table.It isn't show table attribution. solution one:Op 阅读全文
posted @ 2017-11-06 20:48 杨杨yang 阅读(169) 评论(0) 推荐(0) 编辑
OFFICE_EXCEL_Combine text from two or more cells into one cell.
摘要：Excel Enter and format data Layout Combine text from two or more cells into one cell Combine text from two or more cells into one cell Applies To: Exc 阅读全文
posted @ 2017-11-06 00:32 杨杨yang 阅读(871) 评论(0) 推荐(0) 编辑
ORACLE_LPAD_FUNCTION
摘要：Oracle / PLSQL: LPAD Function This Oracle tutorial explains how to use the Oracle/PLSQL LPAD function with syntax and examples. Oracle / PLSQL: LPAD F 阅读全文
posted @ 2017-11-06 00:12 杨杨yang 阅读(175) 评论(0) 推荐(0) 编辑
ORACLE_PROCEDURE_DROPTABLE
摘要：WEBSITE:https://stackoverflow.com/questions/14564641/drop-a-table-in-a-procedure Qusetion:Hou to use procedure drop a table in oracle. Eample Syntax 阅读全文
posted @ 2017-11-04 13:35 杨杨yang 阅读(254) 评论(0) 推荐(0) 编辑
PL/SQL Developer import and export database method and illustrate
摘要：PL/SQL Developer import and export database method and illustrate HOW WELL DO YOU KNOW THE APPLE UNIVERSE? In 2015, Apple became the first company wor 阅读全文
posted @ 2017-11-02 23:23 杨杨yang 阅读(246) 评论(0) 推荐(0) 编辑
ORACLE_TRIGGER
摘要：PL/SQL TRIGGER Statement PL/SQL TRIGGER Statement The trigger statemet is a especially stored procedure.It define some event about database(such as,IN 阅读全文
posted @ 2017-11-02 23:08 杨杨yang 阅读(194) 评论(0) 推荐(0) 编辑
oracle_union_operator
摘要：SQL: UNION Operator This SQL tutorial explains how to use the SQL UNION operator with syntax and examples. SQL: UNION Operator This SQL tutorial expla 阅读全文
posted @ 2017-11-01 23:46 杨杨yang 阅读(399) 评论(0) 推荐(0) 编辑
how to determint wether two column equals
摘要：question: How to determint wether two column equals? Answer: Table one:RecordId = 1,CommonId = 5,Approved = 1. RecordId = 2,CommonId = 5 Approved = 0. 阅读全文
posted @ 2017-11-01 23:24 杨杨yang 阅读(235) 评论(0) 推荐(0) 编辑
how to create folders in batches
摘要：you need be good at thinking when you see problem. Work experience:when you need to copy web chinese,but web can't copy you can press F12 and find cor 阅读全文
posted @ 2017-11-01 21:14 杨杨yang 阅读(156) 评论(0) 推荐(0) 编辑
oracle_How to Recover Data (Without a Backup!）
摘要：How to Recover Data (Without a Backup!） It's the classic career-limiting maneuver(职业限制机动): accidentally deleting data you weren't meant to. It's easy 阅读全文
posted @ 2017-11-01 01:14 杨杨yang 阅读(211) 评论(0) 推荐(0) 编辑


< 2025年3月 >
日 一 二 三 四 五 六
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5
Copyright © 2025 杨杨yang
Powered by .NET 9.0 on Kubernetes Powered By博客园
点击右上角即可分享
微信分享提示