-
编辑 删除
dba_dependencies scripts
set lines 132select distinct owner, name, referenced_name from dba_dependencies where type in ('PACKAGE BODY','PROCEDURE','TRIGGER')and &...
-
编辑 删除
Application Design Basics
Data Normalization: OLTP – 3NF DSS – 2NF Data Type Selection: Choose Correct Data Types Right from the beginning Reduce SQL manipulation and data con...
-
编辑 删除
2NF and 3NF
2NF and 3NFThe 2NF and 3NF are very similar--the 2NF deals with composite primary keys and the 3NF deals with single primary keys. In general, if you do an ER diagram, convert many-to-many relationsh...
-
编辑 删除
ORACLE入门之OLTP和DSS不同数据库设计
* 在线事务处理(OLTP=Online transaction Processing )应用程序ex. 订票系统，生产系统* 决策支持系统(DSS=Decision Suport System )应用程序ex: 数据仓库
-
编辑 删除
Oracle Concepts - pfile and spfile
Introducing the PFILE and SPFILEOracle provides two different types of mutually exclusive parameter files that you can use, PFILE and SPFILE. Let’s look at the PFILE and the SPFILE in a bit more det...
-
编辑 删除
数据库建表原则
数据库建表原则收藏 1. 原始单据与实体之间的关系 可以是一对一、一对多、多对多的关系。在一般情况下，它们是一对一的关系：即一张原始...
