2010/08/02 16:14
[분류없음]
2009년 10월 26일 신혼여행지 몰디브로 가던 중 태국 상공에서...
Trackback Address :: http://sowhat.tistory.com/trackback/89
2008/09/22 16:06
[Tech]
create undo tablespace undotbs2 datafile '/<path>/undotbs02.dbf' size 2000M ;
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs2 scope=both;
select
tablespace_name, contents, extent_management
from dba_tablespaces where contents = 'UNDO';
select segment_name, tablespace_name, status from dba_rollback_segs order by 2;
drop tablespace undotbs1;
Trackback Address :: http://sowhat.tistory.com/trackback/43
2008/09/22 15:29
[Tech]
UPDATE a
SET <update target column of a> = <value>
FROM
<update target table> a,
<join target table > b
where
a.<column> = b.<column>;
ps.
In Oracle
update table a
set column = (select value from table b where a.<column> = b.<column>)
where
<boundary condition>;
SET <update target column of a> = <value>
FROM
<update target table> a,
<join target table > b
where
a.<column> = b.<column>;
ps.
In Oracle
update table a
set column = (select value from table b where a.<column> = b.<column>)
where
<boundary condition>;
Trackback Address :: http://sowhat.tistory.com/trackback/42
