-
Expert Member
Currency Format
SELECT ryotnumber,to_char(sum((netweight*850)),'$ 99,999.99') as grossvalue
FROM cmscaneweighment
WHERE seasoncode='200607'
GROUP BY ryotnumber
ORDER BY grossvalue desc
In the above query if I give Rs instead of $ it is showing error message ORA - 01481 Invalid Number Format Model. How to display Rs before the number while diplaying the output?
-
Expert Member
Re: Currency Format
Follow this
alter session set nls_currency=Rs
SELECT TO_CHAR( SUM(sal), 'L999G999D99') Total FROM EMP
U have to alter the seesion by setting nls_currency to Rs and run ur query
Last edited by susarlasireesha; 12-27-2007 at 04:27 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules