SQL select 和 case 组合

Question

我在使用 select 语句时遇到问题，并且不确定我做错了什么。这是源表的结构:

Source Schema DATA1

Source Table FOLDERS

Source Columns FOLDERID, USERID

Destination Schema DATA1

Destination Table FOLDER_USER

Destination Columns FOLDER_ID, USER_ID

这里是查询(我需要更改文件夹 ID，因为它是从第一个查询中提取出来的，因此是这种情况):

DECLARE
BEGIN
   FOR FOLDER_ROW IN (SELECT FOLDERID = CASE 
                                WHEN FOLDERID = '10' THEN '1'
                                WHEN FOLDERID = '565' THEN '2'
                                WHEN FOLDERID = '11' THEN '3'
                                WHEN FOLDERID = '81' THEN '4'
                                ELSE '0'
                            END, USERID FROM DATA1.FOLDERS WHERE UPPER(OWNER) = 'ADMIN')
      LOOP                       
          INSERT INTO DATA1.FOLDER_USER (FOLDER_ID, CORP_ID) VALUES (FOLDER_ROW.FOLDERID, FOLDER_ROW.CORPID);
     END LOOP;
    COMMIT;
END;

我在执行时收到以下错误，我不知道为什么会收到它。我知道这与 select 中的大小写有关:

ORA-06550: line 3, column 39:
PL/SQL: ORA-00923: FROM keyword not found where expected
ORA-06550: line 3, column 22:
PL/SQL: SQL Statement ignored

Answer 1

SELECT FOLDERID = CASE 错误。它应该是 SELECT CASE ..... END As FOLDERID