insert 数据从select中来

INSERT INTO table1
  (col1, col2, col3, createtime)
  SELECT col1, col2, col3, SYSDATE CREATE_TIME
    FROM ftable F
   where F.col = 'xxx';