03.txt

Oracle database 10g基础教程（第二版） 源码

create table emp_history(
empno integer,
total_pay integer,
update_date date);

insert into emp_history values(1, 100, '08-6月-2006');
insert into emp_history values(2, 200, '15-6月-2006');

create table emp_history_adds(
empno integer,
net_pay integer);

insert into emp_history_adds values(1, 150);
insert into emp_history_adds values(3, 300);

select * from emp_history;

select * from emp_history_adds;

merge into emp_history eh
using emp_history_adds eha
on (eh.empno = eha.empno)
when matched then
update set eh.total_pay = eha.net_pay,
           eh.update_date = '08-8月-2008';








create table names(
name varchar2(30));

insert into names
values (q'[Johnsons's book is very good.]');

select * from names
where name = q'XJohnsons's book is very good.X';