调试经验——Oracle复制一条记录到另外一条记录（主键除外）

问题描述：

想复制一条数据作为测试数据，这样就不用担心破坏原来数据的完整性。

方法：

参考文章：https://blog.csdn.net/New_Yao/article/details/80831120

/* Formatted on 2018/11/6 1:08:22 (QP5 v5.256.13226.35538) */
INSERT INTO STUDENT (STUDENT_ID,
                     FIRST_NAME,
                     LAST_NAME,
                     STREET_ADDRESS,
                     ZIP,
                     PHONE,
                     EMPLOYER,
                     REGISTRATION_DATE,
                     CREATED_BY,
                     CREATED_DATE,
                     MODIFIED_BY,
                     MODIFIED_DATE)
   SELECT '101',
          FIRST_NAME,
          LAST_NAME,
          STREET_ADDRESS,
          ZIP,
          PHONE,
          EMPLOYER,
          REGISTRATION_DATE,
          CREATED_BY,
          CREATED_DATE,
          MODIFIED_BY,
          MODIFIED_DATE
     FROM STUDENT
    WHERE STUDENT_ID = 102