-
编辑 删除
学习Join View-Key-Preserved Tables以及DML Statements on a join view
Previous Section < Day Day Up > Next Section 3.5 DML Statements on a Join ViewA join view is a view based on a join. Special considerations apply when you issue a DML (INSERT, UPDATE, or DELETE) statement against a join view. Ever thought about what happens when you ...
-
编辑 删除
使用Oracle 10g引入的Partition Outer Joins进行统计报表的实现
非常有用的开发新特性，直接上代码：SELECT * FROM employee_expense; EMP_ID YEAR MONTH EXPENSE_CLAIM APPROVED_AMT PAID_DATE---------- ---------- ---------- ------------- ------------ --------- &nbs...
-
编辑 删除
LIKE / NOT LIKE 改写
SELECT nameFROM customerWHERE name LIKE 'W%ies' AND name NOT LIKE '%L%'; NAME------------------------------ Worcester TechnologiesWallace Industries或者使用函数：SELECT nameFROM customerWHERE REGEXP_LIKE(name, '^W([^L]*)ies$');NAME ------------------------------ Worcester Technologi...
-
编辑 删除
SQL查询的转义方法(一)
drop table test1;create table test1(a int, b varchar2(50));insert into test1 values(1,'nihao %25 haha');insert into test1 values(1,'nihao ''25'' haha');commit;1、查询b列含有%的行If you want to find strings containing the % character, you will need to escape the % character within your patte...
