MERGE INTO 
(SELECT SUM(MOVIE_SIZE) AS S FROM HARDDISK
WHERE MOVIE_TYPE = \'S\') B

USING 
(SELECT MAX(MOVIE_INDEX) AS S FROM HARDDISK 
WHERE MOVIE_TYPE = \'S\' ) A

ON (B.S < 1000000000000 )

WHEN MATCHED THEN

INSERT (MOVIE_NAME) VALUES(\'N\' + A.S + .AVI\')

WHEN NOT MATCHED THEN

UPDATE SET B.PLAY_FLAG = \'Y\'



프겔이야기) 외장 하드 추천 좀.