如何把db2的sql转成oracle的

CREATE VIEW NMSGUEST.DB2TBSENTRY(DEVIPADDR,DBINDEX,TABLESPACEINDEX,TABLESPACENAME,TABLESPACESTATE,DEVTYPE)
AS
select varchar(char(integer(A.devID)),20),B.int01,B.int02,B.str01,B.int05,A.neType
from imap_db.INMSNEMO A
inner join imap_db.MOStorageTable B on LEFT(B.fdn,LENGTH(A.fdn)+1)=A.fdn concat '.'
where B.className = 'Db2TBSEntry';


红色那部分看不懂是什么意思?
该如何转换?

---

left函数是从参数1中从取参数2个字符 concat就类似 字符串相加

---

还是不懂,能写出来么.谢谢

---

SQL code:
CREATE VIEW DB2TBSENTRY (DEVIPADDR,DBINDEX,TABLESPACEINDEX,TABLESPACENAME,TABLESPACESTATE,DEVTYPE)
AS
select A.devID,B.int01,B.int02,B.str01,B.int05,A.neType
from imap_db.INMSNEMO A inner join imap_db.MOStorageTable B
on LEFT(B.fdn,LENGTH(A.fdn)+1)=A.fdn || '.'
where B.className = 'Db2TBSEntry';

---

红色部分的作用应该是:以B.fdn的内容是否是以A.fdn+"."开头作为条件将两表相连