database
iteye_16478
这个作者很懒,什么都没留下…
展开
-
recover the tables when using "drop" sentences to do it
today a very urgent thing happened in the project, my colleague droped all the tables of database because of the careleness, there was no other choice we had to face this situation, we thank of man...2009-12-25 12:16:42 · 115 阅读 · 0 评论 -
TRUNCATE 命令用法
TRUNCATE TABLE 在功能上与不带 WHERE 子句的 DELETE 语句相同:二者均删除表中的全部行。但 TRUNCATE TABLE 比 DELETE 速度快,且使用的系统和事务日志资源少。DELETE 语句每次删除一行,并在事务日志中为所删除的每行记录一项。TRUNCATE TABLE 通过释放存储表数据所用的数据页来删除数据,并且只在事务日志中记录页的释放。TRU...原创 2010-05-12 10:03:28 · 318 阅读 · 0 评论 -
Exists Versus In
1 exists just checks for the existence of rows,whereas in checks the acutal values2 exists typically offers better performence than in with subquery原创 2010-05-28 14:27:48 · 76 阅读 · 0 评论 -
plsql questions
1 can one call DDL statement from PL/SQL?one can call DDL statements like Create,DROP,Truncate ,etc from PL/SQL by using the "EXECUTE IMMEDIATE" statement examplesDECLARE var VARCHAR2(100);B...原创 2010-05-28 15:15:38 · 86 阅读 · 0 评论 -
Subquery or join?
Some tasks can be performed in two ways, both by joins and subqueries. Under what situations should we opt for subqueries?Write your query using a subquery instead of a join when it is easier for ...原创 2010-06-01 09:20:01 · 184 阅读 · 0 评论 -
ETL增量抽取(转)
增量是以一个时间段为计量单位,记录该段时间内较以前增加的数据记录。增量抽取是将该段时间内增长的记录查找出来。增量抽取一般有三种抽取模式,用于捕获源系统新增的数据到系目标库中1)、时间戳方式,要求源表中存在一个或多个字段(时间戳),其值随着新纪录的增加而不断增加,执行数据抽取时,程序通过时间戳对数据进行过滤,抽取结束后,程序记录时间戳信息。2)、触发器方式。要求用户在...原创 2010-06-03 09:58:26 · 190 阅读 · 0 评论 -
the sort of oracle lock
the lock is aiming to solve the porblem that when parallel minipupating the database,it can protect the datathe lock is divided into the following:1 S .such as select * from tablename2 RS .such...原创 2010-06-03 15:48:05 · 153 阅读 · 0 评论 -
database snapshot(2)
3 、在源数据库上,创建要同步表的快照日志Create snapshot log on medal_order;原创 2010-06-26 10:57:41 · 119 阅读 · 0 评论 -
the concept of oracle profile
use the create profile statement to create the profile which a set of limits on database resourcesif you assign the profile to the use ,the use can not exceed these limitsSetting Profile Resourc...原创 2010-06-29 08:25:51 · 103 阅读 · 0 评论