multi-table insert command
syntax overviewThere are two types of multi-table insert as follows:INSERT FIRST; andINSERT ALL.Multi-table inserts are an extension to INSERT..SELECT. Syntax is of the following form.:INSERT ALL|FIRS...
oracle 约束(constraint)的几个参数的小研究(转载)
在做ocp的047试卷242题时查询的首先搞清下几个概念:ORACLE中,约束分deferred 跟 immediate 2种:deferred:如果 Oracle 在事务提交(commit)时才对约束执行检查,则称此约束是延迟的(deferred)。如果数据违反了...
ocp考试
从今天开始,为ocp考试做准备,争取能够在10月中旬参加考试。