SQL> desc dept;
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ----------------------------
 DEPTNO                                                         NUMBER(2)
 DNAME                                                          VARCHAR2(14)
 LOC                                                            VARCHAR2(13)

 SQL> ed
Wrote file afiedt.buf

  1  create table my_dept
  2  (my_deptno number,
  3   my_dname varchar2(14),
  4*  my_loc varchar2(13))
SQL> /

Table created.

SQL> insert into my_dept
  2  (select deptno,dname,loc from dept);

4 rows created.

SQL> select * from my_dept;

 MY_DEPTNO MY_DNAME       MY_LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL> commit;