Convert View (Interbase to ORACLE

From: CMA Solutions <cmasol_at_cmasol.com>
Date: 2000/03/02
Message-ID: <6hAv4.1597$Ab1.77279@newsread2.prod.itd.earthlink.net>#1/1

I need your assistance!

Who cant I convert this View (Interbase to ORACLE)

define view ARC_BEC_VUE

            of    B IN ARC_BEC CROSS
                   A IN ANSES
       WITH  B.ABU_ANSES = A.ANS_ANSES
                   A.ANS_SEQ,
                   B.INX_CD_PERM,
                   B.ABU_ANSES,
                   B.ABU_NO_COU,
                   B.ABU_RESULT,
                   B.ABU_REMAR,
                   B.ABU_MOY_GRP,
                   B.ABU_UNI_UEC,
                   B.ABU_CD_COLL,
                   B.ABU_NO_GRO,
                   B.ABU_INS_SERVICE,
                   ABV_NB_SU long computed by (COUNT OF E IN ARC_EQUIVAL_I
                                                                        WITH

E.INX_CD_PERM = B.INX_CD_PERM AND E.COU_NO_COU = B.ABU_NO_COU AND B.ABU_REMAR = 'SU'),

                   ABV_SUB_NO_COU computed by (FIRST   E.EQI_NO_COU

FROM E IN ARC_EQUIVAL_I WITH E.COU_NO_COU = B.ABU_NO_COU AND E.INX_CD_PERM = B.INX_CD_PERM AND B.ABU_REMAR = 'SU' ELSE NULL); Received on Thu Mar 02 2000 - 00:00:00 CST