In oracle, the values of two tables are inserted to each other and the values of the table itself are inserted.

In oracle, the two tables insert values to each other and the table's own insert values have two tables, student and otherStudent, the table information is as follows: SQL> desc studentName Type Nullable Default Comments ---- ------------ ------- -------- NUM NUMBER www.2cto.com NAME VARCHAR2 (20) age number y SQL> desc otherStudentName Type Nullable Default Comments ---- ------------ ------- -------- NUM VARCHAR2 (50) NAME VARCHAR2 (50) Now do the following experiments. Once student has data, I want to insert the data in otherStudent. Insert into otherStudent (num, name) select num, name from student the type or length of the inserted fields in the two tables can still be inserted if they are consistent with each other, indicating that the inserted Table can receive the data, inconsistent type or length does not affect. Www.2cto.com Experiment 2 otherStudent has data. you can insert data from this table into this table and insert into otherStudent select * from otherStudent experiment 3 Statement insert into otherStudent select * from student. The error "too many values" is reported ". Statement insert into student select * from student otherStudent. The error "not enough value" is reported ".