Plsql to spell number (currency) to Italian currency without hardcoded the translation number
Date : March 29 2020, 07:55 AM
will be helpful for those in need I could not find a post to do it automatically as I don't want to hard coded the mapping between English to Italian. CREATE OR REPLACE FUNCTION Currency_conversion(currency IN NUMBER)
RETURN VARCHAR2 IS
txt varchar2(4000);
tlum varchar2(4000);
babelTxt varchar(32000);
req utl_http.req;
resp utl_http.resp;
webtext VARCHAR2(4000);
webextract VARCHAR2(4000);
BEGIN
-- This is used to convert number to words in english
SELECT CAST( to_char( to_timestamp( lpad(currency,9,'0'), 'FF9' ), 'FFSP' ) AS VARCHAR2(100) )
into txt from dual;
-- FFSP is used to spell Fraction second in words for example HH24SP
-- can be used to spell hours from 0 to 23,i used FFSP to get max range
txt:=translate(txt,'x-','x ');
-- The below logic is taken from
-- https://forums.oracle.com/forums/thread.jspa?threadID=1122273(and)start=15(and) tstart=0
--need to test once
-- request that exceptions are raised for error status codes
utl_http.set_response_error_check(enable => TRUE);
-- allow testing for exceptions like Utl_Http.Http_Server_Error
utl_http.set_detailed_excp_support(enable => TRUE);
txt:=utl_url.escape(txt);
babelTxt := 'http://babelfish.yahoo.com/translate_txt?doit=done' || '&' || 'lp=en_it' || '&' || 'intl=1' || '&' || 'ei=utf8' || '&' || 'trtext=' || txt;
req:=utl_http.begin_request(url => babelTxt, method => 'GET');
resp := utl_http.get_response(r => req);
BEGIN
LOOP
--utl_http.read_text(r => resp, data => webtext, len => 32767);
utl_http.read_line(r => resp , data => webtext);
webextract := regexp_substr(webtext,'<div id="result"><div style="padding:0.6em;">(.+)</div></div>');
if webextract is not null
then
select regexp_replace(webextract,'<div id="result"><div style="padding:0.6em;">(.+)</div></div>','\1')
into tlum FROM dual;
end if;
exit when tlum is not null;
END LOOP;
EXCEPTION
WHEN utl_http.end_of_body THEN
NULL;
END;
utl_http.end_response(r => resp);
return tlum;
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(SQLERRM);
return '';
END;
/
exit;
|
display and input number as currency in ExtJS
Date : March 29 2020, 07:55 AM
I wish this helpful for you After playing around, I have another solution, one based on model. Create a non-existent field, such as price_display, and use it to display; Ext.define('app.model.PriceSample', {
extend: 'Ext.data.Model',
field: [
{name: 'price', type: 'int'},
{name: 'price_display', type: 'float', convert: function (value, records) {
if (value) { //on write
record.set('price', value * 1000);
return value;
} else {
return record.get('price') / 1000;
}
}}
]
}
|
ListView to display number as a currency
Tag : chash , By : user182548
Date : March 29 2020, 07:55 AM
may help you . I'm having an issue with my ListView. I want to display value as a currency, i.e , Just remove C then it should works: DisplayMemberBinding="{Binding value, StringFormat=£{0}}"
|
How to display a number with a space between currency and the number
Tag : sql , By : Vorinowsky
Date : October 30 2020, 12:01 AM
hop of those help? I can't find a way to display a number with a space between the currency and the number. If I use the follow syntax: , You can use this (by defining your currency): SELECT to_char(800, 'FML999G990D00', 'NLS_CURRENCY=''$ ''') FROM dual;
|
NumberFormat Text/currency to display after the Number
Date : March 29 2020, 07:55 AM
it helps some times In your second example, your are not using CurrencyFormat() anymore, you are using a universal NumberFormat. You have to define the the way you want to show the digits in your pattern as well. In case your are not familiar with the symbols I used in the pattern ("#, 0, ¤"), you can check the java doc for NumberFormat. NumberFormat numberFormat = NumberFormat.getFormat("#,##0 ¤ /Monat");
String formattedValue = numberFormat.format(300);
|