Oracle insert from select into table with more columns

Question

I want to insert to a table from a select statement  however  there are 3 columns returned from the select statement and the table has 4 columns  I would like to add 0 for all rows in the extra column  Can anyone give me a sample SQL query for that   Thank you

User · Answer

just select  0  as the value for the desired column

User · Answer

Just add in the  0  in your select   INSERT INTO table name  a b c d      SELECT        other table a AS a         other table b AS b         other table c AS c          0  AS d     FROM other table

User · Answer

Put 0 as default in SQL or add 0 into your area of table

[sql] Oracle insert from select into table with more columns

Examples related to sql

Examples related to oracle