请教各位大佬，这条存储过程我是从hana数据库导出的，在or

请教各位大佬，这条存储过程我是从hana数据库导出的，在oracle中该怎么改呀
CREATEPROCEDUREUNIFY_METRO_DATA(
UNIFY_DATEDATEDEFAULT'2016-03-03'
)
BEGIN
VAR_METRO_RAW_TABLE=
SELECT
CASEWHENALIASCARDNOLIKE'0000%'THENSUBSTRING(ALIASCARDNO,5)ELSEALIASCARDNOENDASCARD_NO,
CARDCLASSASCARD_TYPE
FROM
"CC_METRO_EXT"
WHERE
TO_DATE(GETOFFDATETIME)=:UNIFY_DATE
AND
ONSTATIONID!=STATIONID;
VAR_METRO_RESULT=
SELECT
CARD_NO,
COUNT(CARD_NO)ASMETRO_COUNT,
MAX(CARD_TYPE)ASCARD_TYPE
FROM:VAR_METRO_RAW_TABLE
GROUPBYCARD_NO;
VAR_FINAL_RESULT=
SELECT
T1.CARD_NO,
T1.METRO_COUNT,
T1.CARD_TYPE,
T2.IDCARDNO
FROM:VAR_METRO_RESULTAST1
LEFTJOIN"CC_MAP_LITE_EXT"AST2
ON
T1.CARD_NO=T2.ALIASCARDNO
AND
T2.CHOOSEFLAG=1;
DELETEFROM"CC_EVERYDAY_METRO_RECORDS"
WHERECOLLECT_DATE=:UNIFY_DATE;
INSERTINTO"CC_EVERYDAY_METRO_RECORDS"
SELECT
CARD_NOASALIASCARDNO,
CARD_TYPEASCARD_CLASS,
IDCARDNO,
METRO_COUNTASSUBWAY_TIMES,
TO_DATE(:UNIFY_DATE)ASCOLLECT_DATE
FROM:VAR_FINAL_RESULT;
END;