1.
update
t
set
logdate=to_date('2003-01-01','yyyy-mm-dd')
where
logdate=to_date('2001-02-11','yyyy-mm-dd');
2.
select
*
from
t
where
name
in
(select
name
from
t
group
by
name
having
coung(*)>1)
order
by
name;--沒說清楚，到底是升序還是降序
3.
select
ID，NAME，ADDRESS，PHONE，LOGDATE
from
(
select
t.*,row_number()
over(partition
by
name
order
by
name)
rn
from
t
)
where
rn
=
1;
4.
update
t
set
(address,phone)=
(select
address,phone
from
e
where
e.name=t.name);
5.
select
*
from
t
where
rownum
minus
select
*
from
t
where
rownum
也沒什麽特別的地方，有些題目用oracle特有的函數去做會比較簡單，像在第三題中用到的oracle的分析函數，以及在第壹題中用到的oracle的to_char()函數。
這幾個題目主要是看妳能不能使用oracle的函數去處理