xublogs

摘要： a pack slip denotes what should be "packed" for a delivery. It may consolidate several orders to a route, truck or customer. However, in some businesses the pack slip or packing slip shows what has been "picked" for delivery or shipmenta pick sheet denotes what items to pull from 阅读全文

摘要： Oracle9i引入了MERGE命令,你能够在一个SQL语句中对一个表同时执行inserts和updates操作. MERGE命令从一个或多个数据源中选择行来updating或inserting到一个或多个表. Oracle 10g中MERGE有如下一些改进： 1、UPDATE或INSERT子句是可选的 2、UPDATE和INSERT子句可以加WHERE子句 3、ON条件中使用常量过滤谓词来insert所有的行到目标表中,不需要连接源表和目标表 4、UPDATE子句后面可以跟DELETE子句来去除一些不需要的行 首先创建示例表： create table PRODUCTS ( PRODUCT. 阅读全文