Hello DevTeam,
beautifying an IN LIST expression where every item should be in another line does not work so far. All Items in one line
kind regards
/Karl
beautifying an IN LIST expression where every item should be in another line does not work so far. All Items in one line
Code:
SELECT /*+ORDERED*/
Db.name AS Dbname
,Com.id
,Com.legalname
,V00.mifid_Classified
,V00.mifid_Class1
,V00.mifid_Class2
FROM Isis.company Com
,Isis.vw_Mifid_Class_All_Comstr_X2 V00
,V$database Db
WHERE Com.id IN (Hextoraw('0D369197EDD14088E0438C0D97654088'), Hextoraw('C9ABCF5E3C6B8E41A1F24B775AA1FF41'), Hextoraw('E93EE00420D5B9489F7F00513B06ADC3'), Hextoraw('50E0C88C8F35CF4AA0030EE7FAD53E5D'), Hextoraw('652284943021FB43BE3D022D54E94068'), Hextoraw('42DD56D540C7FC49B74613C0E0020E9F'), Hextoraw('0D369198ABAF4088E0438C0D97654088'), Hextoraw('0D369197F44A4088E0438C0D97654088'))
AND V00.lent_Id(+) = Com.id;
kind regards
/Karl
Last edited: