Oracle 复制表数据

最新推荐文章于 2023-10-17 10:31:28 发布

笨小孩xl

最新推荐文章于 2023-10-17 10:31:28 发布

阅读量160

点赞数

文章标签： Oracle 复制表数据

本文链接：https://blog.csdn.net/qq_37538698/article/details/89100337

版权

CREATE TABLE SAF_T_PERIOD_FEEDBACK(
	ID,
	CREATE_DATE,
	FEEDBACK_CONTENT,
	CREATE_UID,
	ACTI_FEEDBACK_ID,
	EXTEND_COL1,
	EXTEND_COL2,
	EXTEND_COL3
) AS SELECT
		ACTI_FEEDBACK_ID,
		CREATE_DATE,
		FEEDBACK_CONTENT,
		CREATE_UID,
		ACTI_FEEDBACK_ID,
		EXECUTE_STATUS,
		CASE WHEN EXECUTE_STATUS = '1' THEN '阶段性反馈'
		WHEN EXECUTE_STATUS = '2' THEN '完成反馈' 
		ELSE '确认' END,
		'1'
FROM
	SAF_T_ACTIVITY_FEEDBACK
WHERE
	1=1
AND
	(
		EXECUTE_STATUS ='1'
		OR
		EXECUTE_STATUS ='2'
	)