Please see the below SQL statement
INSERT INTO table_name
select * form view_object
Case 1:
example table_name has a, b,c as the field names.
View_object has d,e,f as the field names.
The datatypes matches with each field (example a datatype = d datatype, b datatype = e datatype, f datatype = c datatype)
If I execute the above query what will happen ?
Case 2:
example table_name has a, b,c as the field names.
View_object has d,e,f as the field names.
In this case the fields are not having matching datatypes.
When I execute the query what will happen ?
Case 3:
example table_name has a, b,c,d as the field names.
View_object has d,e,f as the field names.
The datatypes matches with each field (example a datatype = d datatype, b datatype = e datatype, f datatype = c datatype)
If I execute the above query what will happen ?
Case 4:
example table_name has a, b,c as the field names.
View_object has a,b,c,e as the field names.
If I execute the above query what will happen ?
