Oracle从select插入到包含更多列的表中

3 回答

• 127

  只需在选择中添加“0”即可 .

  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
  

  回复于 2024-04-28T06:06:55+08:00
• 1

  在SQL中将0设置为默认值或将0添加到表区域中

  回复于 2024-04-28T06:06:55+08:00
• 5

  只需选择“0”作为所需列的值

  回复于 2024-04-28T06:06:55+08:00