GUI sin
Home
Location
Tags
Media
Guestbook
Admin
New Post
database/oracle
실수로 삭제한 쿼리 복구
두억시니
2014. 7. 15. 14:00
1
2
3
4
5
6
7
INSERT
INTO
S_UPDATELOG
SELECT
*
FROM
(
SELECT
*
FROM
S_UPDATELOG AS OF
TIMESTAMP
(SYSTIMESTAMP
-
INTERVAL
'60'
MINUTE) A
WHERE
A.STNO
=
'2009432007'
AND A.CHANGECODE
=
'21'
AND A.CHANGEYEAR
=
'2012'
;
Colored by Color Scripter
cs
공유하기
글 요소
구독하기
GUI sin
저작자표시
1
2
3
4
5
6
7
8
9
10
···
12
더보기