I am building a query, where I am extract values from XML. I am getting output if the xml has values. But if no xml found am getting error I need help to fill those columns with "yet to get" or something.
below is sample query:
Select Column1,Column2,Column3,Column4, extractvalue(xmltype(column5), '/PymtInit:notifyOutwardCrdtTrnsfrStatusReq/') "Response", Extractvalue(Xmltype(Responsemsg) From Table.Name where column5 is not null;
Note: if I give Column5 is not null, I am getting output but I need output without "column5 is not null" also.