by 비디는껌 [2012.07.26 18:54:31]
INSERT INTO board(cd, gb, nm, file_yn, rep_yn) SELECT 'A' || (MAX(SUBSTR(cd, 2))+1) , 0, 'test', 'Y', 'Y' FROM board ;