Oracle you may use the query below to convert SUM of totalPrice to zero when SUM result is null by using COALESCE
select COALESCE(SUM(totalPrice),0) "Total" from productPriceTable
Subscribe to:
Post Comments (Atom)
Popular
-
As you know HTML5 can able to play video file... So this night I spend my time on it and its done :) Why I tried my chance on MKV becau...
-
It is possible to get / copy selected text in web browser control you should use MSHTML . You have to add Microsoft.mshtml in your Refe...
-
You can use the following media formats in HTLM5. As you can see you have many options in HTML5 to play video or audio files. Playing Vid...
-
It was not easy apply bootstrap to Asp.Net Mvc DropDownList. I found this bootstrap-select project on git hub which is a life saver. (Than... -
You can find oracle package errors by executing the query below. select e.owner,e.type,e.line, e.position,e.text, substr(s.text,1,500) sour...
No comments:
Post a Comment