如何将查询结果保存到一个新的列，并将其保存在SQL Oracle Live表中?

Question

这是查询:

SELECT ROUND(column_1,0) as new_column_to_save
FROM table_to_save_to

谢谢

Answer 1

如果你想插入一个新表:

INSERT INTO NEWTableName ( colName)
SELECT ROUND(column_1,0) as new_column_to_save
FROM table_to_save_to

如果要更新同一表中的列

UPDATE table_to_save_to
SET new_column_to_save = ROUND(column_1,0)
FROM table_to_save_to