tag:blogger.com,1999:blog-2473156384972050726.post5956049606400667966..comments2024-03-15T00:37:18.503-07:00Comments on Vishal's blog: Formatting time in BI PublisherVishal Pathakhttp://www.blogger.com/profile/01850811202460421677noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2473156384972050726.post-10191232235152781722014-10-06T22:11:44.228-07:002014-10-06T22:11:44.228-07:00plz tell me how to use NVL function
in xml publis...plz tell me how to use NVL function <br />in xml publisher<br />i require <br />select sum(nvl(comm,0)) from emp group by deptno<br />i used <br /> <br />but it is showing only 0 for all<br />please adviseAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-17267419597351665242013-07-13T04:01:39.083-07:002013-07-13T04:01:39.083-07:00Well difficult to comment without your input XML. ...Well difficult to comment without your input XML. <br />Match it with the SsStartTime tag shown in this blog.<br />In any case, you can always use standard manipulation functions.<br /><br />Example of one such manipulation can also be seen in the blogVishal Pathakhttps://www.blogger.com/profile/16879954344929617672noreply@blogger.comtag:blogger.com,1999:blog-2473156384972050726.post-43049494848545110032013-03-22T04:20:22.376-07:002013-03-22T04:20:22.376-07:00Hi Vishal,
Can you please let me know how can I t...Hi Vishal,<br /><br />Can you please let me know how can I translate if I use the time format mentioned by you.<br />I am using <br />for my requirement and now I am working on the translation of the report. I tried using <br /><br /><br />but in the report the date is also displayed.<br /><br />Please help.<br /><br />Thanks in advance.<br />PurnimaAnonymousnoreply@blogger.com