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) 编辑
INSERT CLAUSE
摘要：a.single table insert b.more table insert
阅读全文
posted @
2017-11-27 21:35
杨杨yang
阅读(141)
推荐(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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
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) 编辑
ORACLE_DELETE
摘要：SQL DELETE Statement The SQL DELETE Statement The DELETE statement is used to delete existing records in a table. DELETE Syntax DELETE FROM table_name
阅读全文
posted @
2017-10-31 23:41
杨杨yang
阅读(285)
推荐(0) 编辑
ORACLE_FUNCTION
摘要：FUNCTION: DEFINE：函数一般用于计算和返回一个值，可以将经常需要使用的计算或功能写成一个函数。 1.basic syntax create [or replace] function fun_name [(parameter1[,parameter2])...] return data
阅读全文
posted @
2017-10-30 22:32
杨杨yang
阅读(192)
推荐(0) 编辑
ORACLE_ALIAS
摘要：Oracle / PLSQL: ALIASES website：https://www.techonthenet.com/oracle/alias.php This Oracle tutorial explains how to use Oracle ALIASES (temporary names
阅读全文
posted @
2017-10-30 19:50
杨杨yang
阅读(327)
推荐(0) 编辑
oracle_procedure
摘要：define： 存储过程（Stored Procedure ）是一组为了完成特定功能的SQL 语句 集，经编译后存储在数据库中。用户通过指定存储过程的名字并给出参数（如果该存储过程带有参数）来执行它。存储过程是数据库中的一个重要对象，任何一个设计良好的数据库应用程序都应该用到存储过程。存储过程是由流
阅读全文
posted @
2017-10-29 23:39
杨杨yang
阅读(791)
推荐(0) 编辑
FUNCTION_POWER
摘要：1.power function Definition:The Oracle PL/SQL, the POWER function is a built in function which takes two numeric inputs and returns numeric（数字的） resul
阅读全文
posted @
2017-10-29 21:41
杨杨yang
阅读(305)
推荐(0) 编辑
installed_oracle_can't_use
摘要：Preface 1.my server is windowsxp 2.database is the oralce 10g step A.CHECK SERVER 1.win + r cmd sqlplsu / as system and test wehter or not use databas
阅读全文
posted @
2017-10-22 21:53
杨杨yang
阅读(119)
推荐(0) 编辑
oracle_set_autocommit
摘要：preface 1.centos operating system. 2.database is oracle 11g. 3.oracle account is scott. step 1.enter into sql windows.follw the below screenshot codes
阅读全文
posted @
2017-10-17 20:17
杨杨yang
阅读(642)
推荐(0) 编辑
oracle temporary table
摘要：oralce 有两种临时表 a.会话级临时表 b.事物级临时表 A.事物级临时表 语法 create global temporary table table_name( col1 type1, col2 type2, ................) on commit delete rows;
阅读全文
posted @
2017-10-11 00:08
杨杨yang
阅读(238)
推荐(0) 编辑
