Due to some reason I can't use Num#() in load script but need to implement same in Select statement (oracle DB) in Load script of QVW. But didn't find exact match of Num#() in oracle, so can someone pls suggest.
Priya, did Vegar's post get things working for you? If so, please be sure to use the Accept as Solution button to mark his post as correct and give him credit. If you are still having issues, leave an update on where things stand. The only other thing I could recommend would be checking the Oracle Community, as they would be the experts on this one as well...
Regarding the Load statement side of things, sometimes you have to use a combination of the formatting functions to get what you really want, just FYI, and in this case, what would have probably helped is if you could have attached a sample QVW with the issue and maybe a QVD with some of the source data, so we could have tried to figure out why things were not working for you in the Load statement.
The following Design Blog post may be of some further help possibly:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.